Display V$/GV$ Views 

Definition

This submonitor in the SAP/Oracle Database Monitor lets you see list the views existing in an Oracle database and display their contents. The list of views is taken from V$fixed_view_definition.

Use

You choose Detailed Analyses ®  Additional Functions ® Display V$/GV$ Views and Values.

You can view history information in this monitor.

Structure

On this screen the column V$Views contains the name of the instance-specific view. For Oracle Real Application Cluster (RAC) the global views, GV$, are also shown.

For each V$ view that has a corresponding table in SAP dictionary, a history is provided. These views are displayed in small letters in the table.

To see more detail, double-click an entry in the table.

The columns displayed in detail depend on the view. For more information, see the Oracle documentation.

Integration

Some features or services in Oracle have their own views. When such features are not active, their related views do not provide any result.

One such feature is the Oracle Log Miner. Its related views (logmnr_*) cannot be queried unless the service is up and running.