Oracle7 Server Concepts

Contents Index Home Previous Next

The Dynamic Performance Tables

Throughout its operation, Oracle maintains a set of "virtual" tables that record current database activity. These tables are called dynamic performance tables.

Because dynamic performance tables are not true tables, they should not be accessed by most users. However, database administrators can query and create views on the tables and grant access to those views to other users.

SYS owns the dynamic performance tables and their names all begin with V_$. Views are created on these tables, and then synonyms are created for the views. The synonym names begin with V$.


Contents Index Home Previous Next