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. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
