Page 217
OEM in Oracle Database 10g offers a number of key improvements:
Much easier to use. OEM makes management, monitoring, and tuning of a database much easier for the beginning and intermediate DBA. With preconfigured SQL queries, DBAs can dive in and manage the Oracle Database. Experienced DBAs will find OEM an adjunct to their own scripts and processes.
Lower cost to implement. OEM is preconfigured and ready to use out of the box.
Complete solution. OEM is a much more complete solution and offers much improved functionality over the previous version. The following table compares and contrasts functional areas of OEM in Oracle9i and OEM in Oracle Database 10g:
Area | OEM 9i | OEM 10g |
Oracle Database | Yes | Yes |
Administration and monitoring | Yes | Yes |
Oracle e-Business Suite | Yes | Yes |
Oracle9iAS | No | Yes |
Oracle Collaboration Suite | No | Yes |
Operating system | Yes | Yes |
Storage | No | Yes |
Network | No | Yes |
Server load balancers | No | Yes |
Hardware | No | Yes |
Integrated. Administration, tuning, software/hardware configuration, etc. source from one single console. OEM does not attempt to manage the operating system and hardware, but rather attempts to reduce the overall workload of the DBA. The focus is to look from the perspective of the application/end user.
Scalable. OEM can manage thousands of systems with ease.