Chapter 11. Managing the Warehouse

What Has to Be Managed

Once the warehouse has been created and is populated with data, it is very important to ensure that it is correctly managed. The warehouse must be configured for optimal performance and availability. Disk, memory, and CPU resources must be managed effectively. In this chapter, we will describe some of the tasks involved in managing a data warehouse and provide advice on how to execute them.

We will make use of the various GUI tools provided in Oracle Enterprise Manager (OEM) to manage our database. There are alternative methods to this approach, but we are sure you will agree that using OEM makes managing the database considerably easier.

This chapter will first provide an introduction to ...

Get Oracle 10g Data Warehousing now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.