Provides a summary of statistics for the Oracle instance, waits and latches.
Toolbar Operations -
Available Operations for Instance Stats tab Refresh: Refreshes all the tab results from the database Reconnect: Reconnects to the database server Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed Refresh Seconds: Enables the interval in which to refresh the tabs if you check the "Auto Refresh" box Auto Refresh: Indicates whether to refresh the tab results automatically every X number of seconds determined by the "Refresh Seconds" Only stats with values > =: Filters the instance stats per value.
Available Operations for Waits tab Refresh: Refreshes all the tab results from the database Reconnect: Reconnects to the database server Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed Refresh Seconds: Enables the interval in which to refresh the tabs if you check the "Auto Refresh" box Auto Refresh: Indicates whether to refresh the tab results automatically every X number of seconds determined by the "Refresh Seconds"
Available Operations for Latches tab Refresh: Refreshes all the tab results from the database Reconnect: Reconnects to the database server Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed Refresh Seconds: Enables the interval in which to refresh the tabs if you check the "Auto Refresh" box 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 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