Page History
...
Stores general information about statements.
| Column Name | Column Description |
|---|---|
ORST_ORST_SHV | Hash value (calculation based on the statement text). |
ORST_TEXT | Text of the statement. |
ORST_TEXT_VARCHAR | First 1299 characters of unformatted text of the statement. |
ORST_IS_FORMATTED | Y/N flag indicating whether the statement text is formatted. |
ORST_BIND_VARIABLES_SUM | Sum of the bind variables. |
ORST_CONSISTENT_HV | Precise's consistent hash value. |
PW_ORSN_STATEMENT_INFO
Stores additional information about statements.
| Column Name | Column Description |
|---|---|
ORSN_STATEMENT_ID | Unique statement identifier. |
ORSN_INSTANCE_ID | Instance ID. |
ORSN_SHV | Hash value calculation based on the statement text. |
ORSN_IS_ALTERNATIVE | The statement is saved as a related statement (alternative for other statement). |
ORSN_SOURCE_TYPE |
|
ORSN_CABINET_NAME | Name of the cabinet. |
ORSN_FOLDER_NAME | Name of the folder. |
ORSN_STATEMENT_NAME | Name of the statement. |
ORSN_ORIG_STMT_ID | For related statements; original statement ID. |
ORSN_USERNAME | Statement's schema. |
ORSN_OPTIMIZER | Not used. |
ORSN_STIME | Last time the statement was updated. |
ORSN_PTIME | Last time the statement was explained. |
ORSN_HASH_VALUE | Oracle's hash value. |
ORSN_SOURCE | Source file name of gathered statements. |
ORSN_STATEMENT_TYPE | Type of the statement (such as select, insert, and so on). |
ORSN_EXPLAIN_ERROR | Oracle error that occurred during an explain. |
ORSN_LAST_COST | Cost of the statement in the last explain. |
ORSN_LAST_PLANID | Plan ID of the last explain. |
ORSN_LAST_PLAN_HASH | Hash value calculation based on the last execution plan of the statement. |
ORSN_LAST_VIEWED | Not used. |
ORSN_COMMENTS | Comments. |
PS_ORSM_SCHEMA_CHANGE_LOG
Stores information about changes made to the database schema, such as adding, dropping, or modifying tables, indexes, or columns.
| Column Name | Column Description |
|---|---|
ORSM_DATABASE_ID | Database ID of the changed object. |
ORSM_CHANGE_TIME | Time of the change. |
ORSM_CHANGE_TYPE | Type of the change (such as new, deleted, or changed). |
ORSM_OWNER | Name of the object's owner. |
ORSM_OBJECT_NAME | Name of the object that was changed. |
ORSM_BASE_OWNER | Name of the base object's owner. |
ORSM_BASE_OBJECT_NAME | Name of the base object. |
ORSM_SUBOBJECT_NAME | Name of the sub-object. |
ORSM_OBJECT_TYPE | Type of the changed object, such as table or index. |
ORSM_COLUMN_NAME | Name of the column of the object that was changed. |
ORSM_FIELD_NAME | Name of the field. |
ORSM_OLD_VALUE | Value of the field as sampled at the previous run. |
ORSM_NEW_VALUE | Value of the field as sampled at the last run. |
ORSM_COLUMN_LIST | List of column names. |
ORSM_DDL_COMMAND | DDL command that created the object. |
PW_ORSN_STRUCTURE_CHANGE_LOG
Stores information about changes to the database structure, such as changes in redo log files, rollback segments, or initialization parameters.
| Column Name | Column Description |
|---|---|
ORSN_DATABASE_ID | Database ID of the changed object. |
ORSN_CHANGE_TIME | Time of the change. |
ORSN_CHANGE_TYPE | Type of the change, such as new, deleted, or changed. |
ORSN_OWNER | Name of the object's owner. |
ORSN_OBJECT_NAME | Name of the object that was changed. |
ORSN_SUBOBJECT_NAME | Name of the sub-object. |
ORSN_OBJECT_TYPE | Type of the changed object, such as table or index. |
ORSN_COLUMN_NAME | Name of the column of the object that was changed. |
ORSN_FIELD_NAME | Name of the field. |
ORSN_OLD_VALUE | Value of the field as sampled at the previous run. |
ORSN_NEW_VALUE | Value of the field as sampled at the last run. |
ORSN_COLUMN_LIST | List of column names. |
PW_ORPS_PW_SIZE
Stores information about the space usage of Precise Oracle-related objects in the PMDB.
| 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_ | |
ORPS_ | |
ORPS_ | |
ORPS_ | |
ORPS_ | |
ORPS_ | |
ORPS_ | |
ORPS_ | |
ORPS_ | |
ORPS_ | |
ORPS_ | |
ORPS_ | |
ORPS_ | |
ORPS_ |
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.