Page History
...
Column Name | Column Description |
---|---|
ORPS_SAMPLE_DATE | Time when the analyzed batch started. |
ORPS_ROW_TYPE | Type of row. |
ORPS_LAST_ANALYZED | Last time the PMDB schema was analyzed. |
ORPS_SCHEMA_USED | Total space (in bytes) used by schema change objects that are related to Precise for Oracle. |
ORPS_SCHEMA_FREE | Total space (in bytes) unused by schema change objects that are related to Precise for Oracle. |
ORPS_SCHEMA_ALLOCATED | Total space (in bytes) allocated to schema change objects that are related to Precise for Oracle. |
ORPS_STATS_USED | Total space (in bytes) used by statistics objects that are related to Precise for Oracle. |
ORPS_STATS_FREE | Total space (in bytes) unused by statistics objects that are related to Precise for Oracle. |
ORPS_STATS_ALLOCATED | Total space (in bytes) allocated to statistics objects that are related to Precise for Oracle. |
ORPS_STRUCT_USED | Total space (in bytes) used by structure objects that are related to Precise for Oracle. |
ORPS_STRUCT_FREE | Total space (in bytes) unused by structure objects that are related to Precise for Oracle. |
ORPS_STRUCT_ALLOCATED | Total space (in bytes) allocated to structure objects that are related to Precise for Oracle. |
ORPS_REP_USED | Total space (in bytes) used by repository objects that are related to Precise for Oracle. |
ORPS_REP_FREE | Total space (in bytes) unused by repository objects that are related to Precise for Oracle. |
ORPS_REP_ALLOCATED | Total space (in bytes) allocated to repository objects that are related to Precise for Oracle. |
ORPS_TOTAL_USED | Total space (in bytes) used by objects that are related to Precise for Oracle. |
ORPS_TOTAL_FREE | Total space (in bytes) unused by objects that are related to Precise for Oracle. |
ORPS_TOTAL_ALLOCATED | Total space allocated to objects that are related to Precise for Oracle. |
PS_ORTA_TABLES_OVER_TIME
Stores information about the table's analyze statistics over time.
Column Name | Column Description |
---|---|
ORTA_DATABASE_ID | ID of the database. |
ORTA_CHANGE_TIME | Date of the change. |
ORTA_OWNER | Owner of the table. |
ORTA_OBJECT_NAME | Name of the table. |
ORTA_EXTENTS | Number of extents in the table. |
ORTA_SEGMENT_BLOCKS | Number of blocks allocated to the table. |
ORTA_NUM_ROWS | Number of rows in the table. |
ORTA_BLOCKS | Number of used data blocks in the table. |
ORTA_EMPTY_BLOCKS | Number of empty (never used) data blocks in the table. |
ORTA_AVG_SPACE | Average amount of freed space (in bytes) in a data block allocated to the table. |
ORTA_CHAIN_CNT | Number of rows in the table that are chained from one data block to another or that have migrated to a new block, requiring a link to preserve the old ROWID. |
ORTA_AVG_ROW_LEN | Average row length in the table in bytes. |
ORTA_LAST_ANALYZED | Date this table was most recently analyzed. |
PS_ORIO_INDEXES_OVER_TIME
Stores information about the index's analyze statistics over time.
Column Name | Column Description |
---|---|
ORIO_DATABASE_ID | ID of the database. |
ORIO_CHANGE_TIME | Date of the change. |
ORIO_OWNER | Owner of the index. |
ORIO_OBJECT_NAME | Name of the index. |
ORIO_TABLE_OWNER | Owner of the table. |
ORIO_TABLE_NAME | Name of the table. |
ORIO_BLEVEL | B*-Tree level: depth of the index from its root block to its leaf blocks. A depth of 0 indicates that the root block and leaf block are the same. |
ORIO_LEAF_BLOCKS | |
ORIO_DISTINCT_KEYS | |
ORIO_AVG_LEAF_BLOCKS_PER_KEY | |
ORIO_ | |
ORIO_ | |
ORIO_ | |
ORIO_ |
ORIO_DATABASE_ID
ORIO_CHANGE_TIME
ORIO_OWNER
ORIO_OBJECT_NAME
ORIO_TABLE_OWNER
ORIO_TABLE_NAME
ORIO_BLEVEL
ORIO_LEAF_BLOCKS Number of leaf blocks in the index.
ORIO_DISTINCT_KEYS Number of distinct indexed values. For indexes that enforce UNIQUE and PRIMARY KEY constraints, this value is the same as the number of rows in the table (USER_TABLES.NUM_ROWS).
ORIO_AVG_LEAF_BLOCKS_PER
_KEY Average number of leaf blocks in which each distinct value in the index appears, rounded to the nearest integer. For indexes that enforce UNIQUE and PRIMARY KEY constraints, this value is always 1.
ORIO_AVG_DATA_BLOCKS_PER
_KEY Average number of data blocks in the table that are pointed to by a distinct value in the index rounded to the nearest integer. This statistic is the average number of data blocks that contain rows with a given value for the indexed columns.
ORIO_CLUSTERING_FACTOR Indicates the amount of order of the rows in the table based on the values of the index.
If the value is nearly the number of blocks, the table is very well ordered. In this case, the index entries in a single leaf block tend to point to rows in the same data blocks.
If the value is nearly the number of rows, the table is very randomly ordered. In this case, it is unlikely that index entries in the same leaf block point to rows in the same data blocks.
ORIO_NUM_ROWS Number of rows in the index.
ORIO_SAMPLE_SIZE Sample size used in analyzing this table.
ORIO_LAST_ANALYZED Date this table was most recently analyzed.