The I/O Times tab on the Tablespace Analysis drilldown contains graphs that let you visually monitor average I/O times and buffer pool hit ratios for a tablespace. The four graphs track the following:
Average amount of time spent on direct I/O.
Average amount of time spent on asynchronous I/O.
Average amount of time spent on physical I/O.
Buffer pool hit ratios.
All four graphs use counter data to show statistics as they change over time. This allows you to see when average I/O times are high and buffer pool hit ratios are low for a tablespace.
Consistently high I/O times can be a symptom of I/O conflict. Consistently low hit ratios can be a sign that a buffer pool is not operating efficiently. Both problems degrade performance. To identify applications that are contributing to I/O conflict, work from the Client Application Analysis drilldown. To investigate buffer pool conditions, work from the Buffer Pool Analysis drilldown.
Click the links below to see descriptions of each graph in the I/O Times tab:
As you view graphs in the I/O Times tab, you can click icons in graph toolbars to:
Copy graph details to the clipboard
The Quiescers tab on the Tablespaces drilldown provides information about quiescer activity that is currently in progress. It shows the type of quiesce being performed. It also shows information that can help identify who is responsible for quiescing a tablespace. This information is shown in the Agent ID, Authorization ID, OBID, Tablespace ID columns.
All columns available for the Quiescers tab are listed below in alphabetic order. Initially, the tab contains Spotlight's default column selection. You can choose which columns to display and organize them in any order from left to right using the Organize Columns function. This can be selected from the right-click menu for column headers.
|
Column |
Description |
|
Agent ID |
The ID of the agent holding a quiesce state. |
|
Authorization ID |
The authorization ID of the user holding a quiesce state. This is the ID that was used to connect to the database. |
|
OBID |
The object ID of the object that caused a tablespace to be quiesced. |
|
State |
The quiescer state. This indicates the type of quiesce being performed. For example, the type might be SHARE, INTENT TO UPDATE, or EXCLUSIVE. |
|
Tablespace ID |
The tablespace ID of the object that caused a table space to be quiesced. |
The Ranges tab on the Tablespaces drilldown shows how ranges are defined for range partitioning in DMS tablespaces. When an aggregate tablespace row is selected, the tab shows partitioning information for a tablespace across all database partitions. When the row for an individual tablespace is selected, the tab shows partitioning information for the partition on which the tablespace is defied.
Note: Information in the Ranges tab applies only to DMS tablespaces. It does not apply to SMS tablespaces.
All columns available for the Ranges tab are listed below in alphabetic order. Initially, the tab contains Spotlight's default column selection. You can choose which columns to display and organize them in any order from left to right using the Organize Columns function. This can be selected from the right-click menu for column headers.
|
Column |
Description |
|
Adjustment |
Any offset into the container array in which a range starts. |
|
Container ID |
The ID that uniquely identifies a container within a range. |
|
Containers |
The number of containers in a range. |
|
End Stripe |
The number of the last stripe in a range. |
|
Max Extent |
The maximum extent number that is mapped by a range. |
|
Max Page |
The maximum page number that is mapped by a range. |
|
Number |
The number of a range in the tablespace map. |
|
Offset |
The offset from stripe 0 of the beginning of the stripe set to which a range belongs. |
|
Start Stripe |
The number of the first stripe in a range. |
|
Stripe Set |
The number of the stripe set to which a range belongs. |
The Statistics tab on the Tablespaces drilldown lists performance statistics for database events associated with the selected tablespace. Each row in the list identifies a specific event and provides countsfor the event based on these time measurements:
Interval—Displays the number of occurrences of the event for the most recent monitoring interval.
Rate—Displays the rate per second during the most recent monitoring interval.
Lifetime—Displays the number of occurrences during the life of the event (since the database was activated or performance statistics were reset).
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
