11 – Managing the Warehouse

This chapter discusses some of the tasks required to manage a warehouse, examines new features available in Oracle database 10 g to help with this, and uses oracle enterprise manager (OEM) to simplify management of the warehouse. This chapter makes use of the various graphic user interface (GUI) tools provided in OEM to manage the database. With Oracle database 10 g , enterprise manager changed from the Java-based GUI tool to an easily accessible interface accessed via any browser on wide area network. There are two named variants of enterprise manager: database control and grid control. For managing an individual database and its ASM storage, EM database control is used. This chapter discusses various tasks such as reorganizing the warehouse, gathering optimizer statistics, maintaining security, and monitoring space usage, and introduces techniques for periodic reorganization using partition maintenance operations and online redefinition. Developing a test system and a business continuity plan are important considerations in this chapter.