Since this chapter is not meant to be a detailed explanation of all of the Enterprise Manager features, readers are requested to refer to the Enterprise Manager Concepts guide and Enterprise Manager Advanced Configuration guide for more details. Installation and setup of Oracle Enterprise Manager will be reviewed in the next chapter.

Conclusion

This chapter has reviewed the major architectural changes including performance improvement, storage management, space management, system resources, application tuning and backup and recovery management on Oracle 10g. The topics included:

• Automatic diagnosis of performance problems and correction being facilitated by ADDM and AWR.
   

• Rule-based optimization (RBO) being de-supported.
   

• SYSAUX tablespace providing storage to all non SYS-related objects that would have been placed in the SYSTEM tablespace.
   

• Automatic Storage Management (ASM) providing efficient management of disk drives.
   

• Cross-platform transportable tablespaces enabling the DBA to migrate tablespaces across different platforms.
   

• Automatic SQL Tuning being done by SQL Tuning Advisor and SQLAccess Advisor.
   

• Data Pump utilities providing a high speed infrastructure for data and metadata movement unheard of using export/import utilities.
   

• Flashback functionality being extended to the database level.
   

• Oracle Enterprise Manager managing all hardware and software environments including Grid control.

With a glimpse of all the new features of Oracle Database 10g in mind, the next step will be reviewing the installation process for a database.