Oracle DBA Tools - Server Statistics Provides a summary of statistics for the Oracle instance, waits and latches. | |
Toolbar Operations - Available Operations for Instance Stats tab Available Operations for Waits tab Available Operations for Latches tab | |
Instance Stats Tab - Provides a lists of instance 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 |
.