7.3 The Instance Viewer Page
Available only if you signed in as a database user with DBA and PDB_DBA roles.
To navigate to the Instance Viewer page, do either of the following:
-
In the Database Actions page, click Instance Viewer.
-
Click Selectorto display the left navigation pane. Expand the Monitoring menu and select Instance Viewer.
When hovering over a chart, a dark blue border indicates that you can click to drill down to the relevant page for more detailed information.
The types of information displayed include:
-
Database
-
Clients
-
Sessions
-
Processes (Counts, Execution Rate, Parse Rate, Open Cursors, Commit Rate)
-
Waits
-
Memory (DB Block Rate, Logical Reads, Allocation, Redo Generation)
-
Storage (Files, Redo Log)
-
DB CPU Ratio (database operations as a percentage of CPU activity)
-
Top SQL (provides performance metrics on SQL operations, which are sorted based on the CPU time required)