9.3 The Instance Viewer Page
Available only if you signed in as a database user with DBA and PDB_DBA
roles.
To reach the Instance Viewer page, click Instance Viewer in the
Database Actions page, or click Selectorand select Instance Viewer from the Monitoring menu in the navigation
pane.
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)