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

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


 


.

  • No labels