-
Title
What do the database monitor fields mean? -
Description
Please explain what each field in the database monitor window means.
-
Resolution
Database Monitor….
Logical IO
The Logical IO chart graphs the usage of Logical Input/Output. The horizontal bar of the graph represents time passed and the vertical represents blocks per second for Block Changes, Current Reads, and Consistent reads
Physical IO
The Physical IO chart graphs usage of the physical input/output. The horizontal bar represents the times data was collected, and the vertical bar represents IO per second, broken into datafile reads, datafile writes, and redo writes.
Event Waits
The Event Waits chart graphs the milliseconds waited per second on a particular usage. The horizontal bar represents the times data was collected on these features, and the vertical bar represents milliseconds waited per second.
Note: Other only includes the following wait events: control file sequential read, control file single write, control file parallel write, db file sequential read, db file scattered read, direct path read, file identify, file open, SQL*Net message to client, SQL*Net message to dblink, SQL*Net more data to client, SQL*Net more data to dblink, SQL*Net break/reset to client, SQL*Net break/reset to dblink, log file single write, and log file parallel write
Sessions
The sessions chart graphs the sessions used during the times monitored. The vertical bar represents the sessions, breaking the chart into Idle, Active, and System sessions. The horizontal bar represents the times data was collected
Call Rates
The Call Rates chart graphs calls per second for Parse, Execute, Commit, and Rollback events.
Miss Rates
The Miss Rates chart graphs percent missed for the Buffer Cache, SQL area, and Latch.
SGA Memory Usage
The SGA Memory usage chart graphs memory usage for Fixed SGA, Log Buffer, Buffer Cache, Shared Pool, Large Pool, and Java Pool. The vertical bar represents kilobytes used
Shared Pool
The Shared Pool usage chart graphs memory usage for the Shared pool in more detail than the SGA Memory Usage chart. It includes usage for Miscellaneous, Dictionary Cache, Library Cache, Free memory, and the SQL Area. The vertical bar represents kilobytes used.
Indexed Queries %
The Indexed Queries % chart graphs memory used for indexed queries and non-indexed queries. The vertical bar represents the percent of total queries performed.