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 |
|
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) |
|
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 |
|
