Oracle DBA Tools - Server Statistics
Provides a summary of statistics for the Oracle instance, waits and latches.
|
Toolbar Operations -
Refresh: Refresh all the tab results from the database
Refresh Seconds: The interval in which to refresh the tabs if "Auto Refresh" is enabled
Auto Refresh: Indicates whether to refresh the tab results automatically every X number
of seconds determined by the "Refresh Seconds"
|
Instance Stats Tab - Provides a lists of system statistics
Stat Number: Statistic number
Name: Statistic name
Value: Statistic value
|
 Oracle DBA Tools - Statistics - Instance Statistics Tab |
Waits Tab - Provides information on total waits for system events
System Event: Name of the wait event
Total Waits: Total number of waits for the event
Timeouts: Total number of timeouts for the event
Time Waited: Total amount of time waited for the event (in hundredths of a second)
|
 Oracle DBA Tools - Statistics - Waits Tab |
Latches Tab - Provides aggregate latch statistics for both parent and child latches
Gets: Number of times the latch was requested in willing-to-wait mode
Misses: Number of times the latch was requested in willing-to-wait mode and
the requestor had to wait
Latch Statistics: Latch name
Simple Gets: (Gets-Misses)
Simple Gets Ratio: (Gets-Misses)/Gets/100
Spin Gets: Willing-to-wait latch requests which missed the first try but succeeded while spinning
Spin Gets Ratio: (100 * Spin Gets / Gets / 100)
Sleep Gets: (Misses-Spin Gets)
Sleep Gets Ratio: 100 * (Misses-Spin Gets) / Gets / 100
|
 Oracle DBA Tools - Statistics - Latches Tab |
