Collection Information
Use this page to view general information about a collection or a system catalog table in a database.
- Type
- Collection or System Catalog table.
- Collection ID
- Collection ID.
- Number of columns
- Number of columns in the collection.
- Number of rows
- Number of rows in the collection.
- Row size
- The row size in bytes.
- Dbspace
- The dbspace that contains the collection or Fragmented Table if the table is a fragmented table that resides in multiple dbspaces.
- Interval fragmentation
- For tables that are created with a Date-range fragmentation or
a Range fragmentation scheme. The column that
is used as the basis for the fragmentation. The integer interval or
the date-range interval. Store in shows the
dbspaces where the data is stored.
The rolling window options are the threshold: maximum fragments or the maximum total size of the table, the purge policy for the oldest fragment: detach or discard, and the intervals that are eligible for removal.
- Lock level
- Lock mode for the table: page, row, or table.
- Data pages
- The number of data pages that have ever been initialized by the database server.
- First extent
- The size of the first extent in kilobytes.
- Next extent
- The size of the next extent in kilobytes.
- Compressed
- An indicator of whether compression is enabled for the collection.
- Row auditing
- An indicator of whether the table is included in row-level auditing when selective row-level auditing is enabled for the database server.
- Grid table
- An indicator if the table is in a grid table list. Grid queries can be run against this table in the context of the grid. This table can be altered only in the context of the grid.
- Grid
- The name of the grid if the table is in a grid table list. A table can be in the grid table list for only one grid.