Monitoring Performance

Each Oracle database instance maintains a set of virtual tables that record current database activity. These tables are called dynamic performance tables. The dynamic performance tables collect data on internal disk structures and memory structures. Among them are tables that collect data on Oracle OLAP. By monitoring these tables, you can detect usage trends and diagnose system bottlenecks.

OLAP dynamic performance tables and associated views are described in Chapter 7, "OLAP Dynamic Performance Views".