PW_PWII_INSTANCE_ID
Defines the instances in the Precise installation.
Column Name | Column Description |
---|---|
PWII_ID | ID of the instance. Columns of XXXX_PWII_INSTANCE_ID have values from the column. |
PWII_INSTANCE_NAME | Name of the instance. |
PWII_TECHNOLOGY | Two characters defining the technology of the instance (such as OR for Oracle and JE for J2EE). |
PWII_SERVER | Name of the server on which the instance is installed. |
PW_ORAS_APPLICATION_STATS_T
Stores application performance statistics per hour for every combination of program, user, host user, machine, module, action, and work type.
The _T
table summarizes the data per timeslice.
The _D
table summarizes the data per day.
The _W
table summarizes the data per week.
The _M
table summarizes the data per month.
(N <table_name>)
means normalized, the actual name can be retrieved from the <table_name>
.
Column Name | Column Description |
---|---|
ORAS_PROGRAM_ID | The ID of the program that made the Oracle connection (N PW_ORPR_PROGRAM_NAME_N) . |
ORAS_USER_ID | ID of the Oracle schema to which the program is connected (N PW_ORUS_USER_NAME_N) . |
ORAS_HOST_USER_ID | ID of the host user running the program (N PW_ORHU_HOST_USER_NAME_N) . |
ORAS_MACHINE_ID | ID of the operating system machine running the program (N PW_ORMC_MACHINE_NAME_N) . |
ORAS_MODULE_ID | ID of the session’s action as set by calling dbms_application_info.set_module (N PW_ORMD_MODULE_NAME_N) . |
ORAS_ACTION_ID | ID of the session’s action as set by calling dbms_application_info.set_action (N PW_ORAT_ACTION_NAME_N) . |
ORAS_WORK_TYPE | ERP work type. |
ORAS_TIMESTAMP | Time the session was sampled. |
ORAS_MINUTES_COUNT_SUM | Number of minutes summed in the row. |
ORAS_PWHG_ID | ID of the hour group that matches the time sampled. |
ORAS_DURATION_SUM | Total elapsed time. |
ORAS_IN_ORACLE_TIME_SUM | Total time spent in Oracle. |
ORAS_REQUEST_WAIT_TIME_SUM | Total time spent in waiting for client requests. |
ORAS_OR_OR_COMM_WAIT_TIME_SUM | The time Oracle spent waiting for another Oracle instance. |
ORAS_RSRC_MNGR_WAIT_TIME_SUM | The time Oracle spent waiting for a resource to become available if the database resource manager had been enabled. |
ORAS_RAC_OPS_WAIT_TIME_SUM | The time Oracle spent waiting for RAC or OPS synchronization. |
ORAS_OR_CL_COMM_WAIT_TIME_SUM | The time Oracle spent waiting for data sent to the client (usually as a result of a select statement), or data send from a client (usually as a result of bind variables). |
ORAS_MTS_WAIT_TIME_SUM | Total time spent waiting for a multithreaded server. |
ORAS_MISC_TIME_SUM | Total time spent waiting for miscellaneous waits. |
ORAS_USING_CPU_TIME_SUM | Total time of CPU use. |
ORAS_CPU_WAIT_TIME_SUM | Total time spent waiting for CPU. |
ORAS_IO_WAIT_TIME_SUM | Total time spent waiting for I/O. |
ORAS_MEMORY_WAIT_TIME | Total time spent waiting for memory. |
ORAS_OTHER_HOST_WAIT_TIME_SUM | Total time spent waiting for another host. |
ORAS_TABLE_LOCK_WAIT_TIME_SUM | Total time spent waiting for a table lock. |
ORAS_ROW_LOCK_WAIT_TIME_SUM | Total time spent waiting for a row lock. |
ORAS_SHARED_POOL_WAIT_TIME_AUM | Total time spent waiting for a shared pool (library cache or row cache). |
ORAS_BUFFER_WAIT_TIME_SUM | Total time spent waiting for buffers. |
ORAS_ROLLBACK_SEG_WAIT_TIME_SUM | Total time spent waiting for a rollback segment. |
ORAS_REDO_BUFFER_WAIT_TIME | Total time spent waiting for redo log buffers. |
ORAS_LOG_S_AND_C_WAIT_TIME_SUM | Total time spent waiting for a log switch and clear waits. |
ORAS_OTHER_LOCK_WAIT_TIME_SUM | Total time spent waiting for other locks (streams, latches, and internal locks in Oracle). |
ORAS_BG_PROCESS_WAIT_TIME_SUM | Total time spent waiting for a background process. |
ORAS_PQ_SYNC_WAIT_TIME_SUM | Total time spent waiting for parallel query synchronization. |
ORAS_PQ_SERVER_WAIT_TIME_SUM | Total time spent waiting for a parallel query server. |
ORAS_OTHER_WAIT_TIME_SUM | Total time spent waiting for other waits. |
ORAS_CONSISTENT_GETS_STAT_SUM | Total number of buffers for a consistent read. |
ORAS_DB_BLOCK_GETS_STAT_SUM | Total number of buffers for a current read. |
ORAS_OTR_INT_LCK_WAIT_STAT_SUM | Total number of enqueue waits. |
ORAS_PARSE_COUNT_TOTL_STAT_SUM | Total number of times PARSE was called. |
ORAS_PARSE_COUNT_HARD_ST_AT_SUM | Total number of times PARSE HARD was called (had to re-parse). |
ORAS_PARSE_TIME_CPU_STAT_SUM | Total CPU time spent on parsing. |
ORAS_RECURSIVE_CALLS_STAT_SUM | Total number of recursive calls. |
ORAS_SORT_MEMORY_STAT_SUM | Total number of sorts done in memory. |
ORAS_SORT_DISK_STAT_SUM | Total number of sorts done on disk. |
ORAS_TABLE_SCAN_LONG_STAT_SUM | Total number of long table scans. |
ORAS_USER_CALLS_STAT_SUM | Total number of user calls. |
ORAS_PHYSICAL_READS_STAT_SUM | Total number of disk reads. |
ORAS_PWII_INSTANCE_ID | ID of the instance. |
ORAS_OPENS_AND_FETCHES_SUM | Total number of open and fetches. |
ORAS_SESSIONS_SUM | Total number of sessions. |
ORAS_INTERPOINT_MODE | Interpoint mode - OA/SAP/PS. |
ORAS_RECEIVED_TIMESTAMP | Timestamp at which the row was loaded into the PMDB. |
ORAS_SEC_PROG_ID | Reserved column. |
ORAS_EXEC_NO_SUM | Total number of executions. |
PW_ORSA_STMT_APPL_STATS_T
Stores statistics about the performance of statements inside applications per hour for every combination of program, user, host user, machine, module, action, and work type.
The _T
table summarizes the data per timeslice.
The _D
table summarizes the data per day.
The _W
table summarizes the data per week.
The _M
table summarizes the data per month.
(N <table_name>)
means normalized, the actual name can be retrieved from the <table_name>
.
Column Name | Column Description |
---|---|
ORSA_PROGRAM_ID | ID of the program that made the Oracle connection (N PW_ORPR_PROGRAM_NAME_N ). |
ORSA_USER_ID | ID of the Oracle schema the program connected to (N PW_ORUR_USER_NAME_N ). |
ORSA_HOST_USER_ID | ID of the host user running the program (N PW_ORHU_HOST_USER_NAME_N ). |
ORSA_MACHINE_ID | ID of the operating system machine running the program (N PW_ORMC_MACHINE_NAME_N ). |
ORSA_MODULE_ID | ID of the session's action as set by calling dbms_application_info.set_module (N PW_ORMD_MODULE_NAME_N ). |
ORSA_ACTION_ID | ID of the session's action as set by calling dbms_application_info.set_action (N PW_ORAT_ACTION_NAME_N ). |
ORSA_WORK_TYPE | The ERP work type. |
ORSA_SHV | The statement hash value. |
ORSA_TIMESTAMP | Time the session was sampled. |
ORSA_PWHG_ID | ID of the hour group that matches the time sampled. |
ORSA_DURATION_SUM | Total elapsed time. |
ORSA_IN_ORACLE_TIME_SUM | Total time spent inside Oracle. |
ORSA_REQUEST_WAIT_TIME_SUM | Total time spent waiting for client requests. |
ORSA_OR_OR_COMM_WAIT_TIME_SUM | Total time Oracle spent waiting for another Oracle instance. |
ORSA_RSRC_MNGR_WAIT_TIME_SUM | The time Oracle spent waiting for a resource to become available, if the database manager is enabled. |
ORSA_RAC_OPS_WAIT_TIME_SUM | The time Oracle spent waiting for RAC or OPS synchronization. |
ORSA_OR_CL_COMM_WAIT_TIME_SUM | The time Oracle spent waiting for data sent to the client (usually as a result of a SELECT statement), or data sent from a client (usually as a result of bind variables). |
ORSA_MINUTES_COUNT_SUM | Total amount of minutes summed in that row. |
ORSA_MTS_WAIT_TIME_SUM | Total time spent waiting for a multithreaded server. |
ORSA_MISC_TIME_SUM | Total time spent waiting for miscellaneous waits. |
ORSA_USING_CPU_TIME_SUM | Total time of CPU use. |
ORSA_CPU_WAIT_TIME_SUM | Total time spent waiting for CPU. |
ORSA_IO_WAIT_TIME_SUM | Total time spent waiting for I/O. |
ORSA_MEMORY_WAIT_TIME_SUM | Total time spent waiting for memory. |
ORSA_OTHER_HOST_WAIT_TIME_SUM | Total time spent waiting for another host. |
ORSA_TABLE_LOCK_WAIT_TIME_SUM | Total time spent waiting for a table lock. |
ORSA_ROW_LOCK_WAIT_TIME_SUM | Total time spent waiting for a row lock. |
ORSA_SHARED_POOL_WAIT_TIME_SUM | Total time spent waiting for a shared pool (library cache or row cache). |
ORSA_BUFFER_WAIT_TIME_SUM | Total time spent waiting for buffer waits. |
ORSA_ROLLBCK_SEG_WAIT_TIME_SUM | Total time spent waiting for a rollback segment. |
ORSA_REDO_BUFFER_WAIT_TIME_SUM | Total time spent waiting for redo log buffers. |
ORSA_BG_PROCESS_WAIT_TIME_SUM | Total time spent waiting for a background process. |
ORSA_PQ_SYNC_WAIT_TIME_SUM | Total time spent waiting for a parallel query synchronization. |
ORSA_PQ_SERVER_WAIT_TIME_SUM | Total time spent waiting for a parallel query server. |
ORSA_OTHER_WAIT_TIME_SUM | Total time spent waiting for other waits. |
ORSA_CONSISTENT_GETS_STAT_SUM | Total number of buffers for a consistent read. |
ORSA_DB_BLOCK_GETS_STAT_SUM | Total number of buffers for a current read. |
ORSA_EXEC_COUNT_TOTAL_STAT_SUM | Total number of times EXECUTE was called. |
ORSA_PARSE_COUNT_TOTL_STAT_SUM | Total number of times PARSE was called. |
ORSA_PARSE_COUNT_HARD_STAT_SUM | Total number of times PARSE HARD was called (had to re-parse). |
ORSA_PARSE_TIME_CPU_STAT_SUM | Total CPU time spent on parsing. |
ORSA_RECURSIVE_CALLS_STAT_SUM | Total number of recursive calls. |
ORSA_SORT_MEMORY_STAT_SUM | Total number of sorts done in memory. |
ORSA_SORT_DISK_STAT_SUM | Total number of sorts done on disk. |
ORSA_TABLE_SCAN_LONG_STAT_SUM | Total number of long table scans. |
ORSA_USER_CALLS_STAT_SUM | Total number of user calls. |
ORSA_PHYSICAL_READS_STAT_SUM | Total number of disk reads. |
ORSA_PWII_INSTANCE_ID | ID of the instance. |
ORSA_OPENS_AND_FETCHES_SUM | Total number of open and fetches. |
ORSA_SESSIONS_SUM | Total number of sessions. |
ORSA_PARENT_SHV | Name of the PL/SQL that ran the SQL statement. |
ORSA_MIN_PARALLEL_DEGREE_MIN | Minimum parallel degree used to run the statement. |
ORSA_MAX_PARALLEL_DEGREE_MAX | Maximum parallel degree used to run the statement. |
ORSA_RED_SUM | SLA breach. |
ORSA_YELLOW_SUM | SLA near breach. |
ORSA_GREEN_SUM | SLA okay. |
ORSA_START_BIT_MAP | Internal use. |
ORSA_INTERPOINT_MODE | Interpoint mode - OA/SAP/PS. |
ORSA_RECEIVED_TIMESTAMP | Timestamp at which the row was loaded into the PMDB. |
ORSA_LOG_S_AND_C_WAIT_TIME_SUM | Total time spent waiting for a log switch and clear waits. |
ORSA_OTHER_LOCK_WAIT_TIME_SUM | Total time spent waiting for other locks (streams, latches, and internal locks in Oracle). |
ORSA_OTR_INT_LCK_WAIT_STAT_SUM | Total number of enqueue waits. |
ORSA_RECEIVED_TIMESTAMP | Timestamp at which the row was loaded into the PMDB. |
ORSA_BUFFER_GETS_SUM | Total time spent getting buffers. |
ORSA_ROWS_PROCESSED_SUM | Total number of rows processed. |
ORSA_EXEC_NO_SUM | Total number of executions. |
ORSA_SQL_ID_MIN | Minimum Oracle's SQL ID. |
ORSA_HASH_VALUE_MIN | Minimum Oracle's hash value |
ORSA_PLAN_HASH_VALUE | Oracle's plan hash value. |
ORSA_END_OF_FETCH_COUNT_SUM | Number of END OF FETCHs. |
ORSA_VERSION_COUNT_MAX | Number of statement versions. |
PW_ORSS_STATEMENTS_STATS_T
Stores statistics about statement performance per hour.
The _T
table summarizes the data per timeslice.
The _D
table summarizes the data per day.
The _W
table summarizes the data per week.
The _M
table summarizes the data per month.
(N <table_name>)
means normalized, the actual name can be retrieved from the <table_name>
.
Column Name | Column Description |
---|---|
ORSS_SHV | The statement hash value. |
ORSS_TIMESTAMP | Time the session was sampled. |
ORSS_PWHG_ID | ID of the hour group that matches the time sampled. |
ORSS_DURATION_SUM | Total elapsed time. |
ORSS_IN_ORACLE_TIME_SUM | Total time spent inside Oracle. |
ORSS_REQUEST_WAIT_TIME_SUM | Total time spent waiting for client requests. |
ORSS_OR_OR_COMM_WAIT_TIME_SUM | Total time Oracle spent waiting for another Oracle instance. |
ORSS_RSRC_MNGR_WAIT_TIME_SUM | The time Oracle spent waiting for a resource to become available, if the database manager is enabled. |
ORSS_RAC_OPS_WAIT_TIME_SUM | The time Oracle spent waiting for RAC or OPS synchronization. |
ORSS_OR_CL_COMM_WAIT_TIME | The time Oracle spent waiting for data sent to the client (usually as a result of a SELECT statement), or data sent from a client (usually as a result of bind variables). |
ORSS_MINUTES_COUNT_SUM | Total amount of minutes summed in that row. |
ORSS_MTS_WAIT_TIME_SUM | Total time spent waiting for a multithreaded server. |
ORSS_MISC_TIME_SUM | Total time spent waiting for miscellaneous waits. |
ORSS_USING_CPU_TIME_SUM | Total time of CPU use. |
ORSS_CPU_WAIT_TIME_SUM | Total time spent waiting for CPU. |
ORSS_IO_WAIT_TIME_SUM | Total time spent waiting for I/O. |
ORSS_MEMORY_WAIT_TIME_SUM | Total time spent waiting for memory. |
ORSS_OTHER_HOST_WAIT_TIME_SUM | Total time spent waiting for another host. |
ORSS_TABLE_LOCK_WAIT_TIME_SUM | Total time spent waiting for a table lock. |
ORSS_ROW_LOCK_WAIT_TIME_SUM | Total time spent waiting for a row lock. |
ORSS_SHARED_POOL_WAIT_TIME_SUM | Total time spent waiting for a shared pool (library cache or row cache). |
ORSS_BUFFER_WAIT_TIME_SUM | Total time spent waiting for buffer waits. |
ORSS_ROLLBACK_SEG_WAIT_TIME_SUM | Total time spent waiting for a rollback segment. |
ORSS_REDO_BUFFER_WAIT_TIME_SUM | Total time spent waiting for redo log buffers. |
ORSS_LOG_S_AND_C_WAIT_TIME_SUM | Total time spent waiting for a log switch. |
ORSS_OTHER_LOCK_WAIT_TIME | Other lock wait is for all the locking that does not fall in the other locking states. It is for Streams, Latches and other internal locking in Oracle. |
ORSS_BG_PROCESS_WAIT_TIME_SUM | Total time spent waiting for a background process. |
ORSS_PQ_SYNC_WAIT_TIME_SUM | Total time spent waiting for a parallel query synchronization. |
ORSS_PQ_SERVER_WAIT_TIME_SUM | Total time spent waiting for a parallel query server. |
ORSS_OTHER_WAIT_TIME_SUM | Total time spent waiting for other waits. |
ORSS_CONSISTENT_GETS_STAT_SUM | Total number of buffers for a consistent read. |
ORSS_DB_BLOCK_GETS_STAT_SUM | Total number of buffers for a current read. |
ORSS_OTR_INT_LCK_WAIT_STAT_SUM | Total number of enqueue waits. |
ORSS_EXEC_COUNT_TOTAL_STAT_SUM | Total number of times EXECUTE was called. |
ORSS_PARSE_COUNT_TOTL_STAT_SUM | Total number of times PARSE was called. |
ORSS_PARSE_COUNT_HARD_STAT_SUM | Total number of times PARSE HARD was called (had to re-parse). |
ORSS_PARSE_TIME_CPU_STAT_SUM | Total CPU time spent on parsing. |
ORSS_RECURSIVE_CALLS_STAT_SUM | Total number of recursive calls. |
ORSS_SORT_MEMORY_STAT_SUM | Total number of sorts done in memory. |
ORSS_SORT_DISK_STAT_SUM | Total number of sorts done on disk. |
ORSS_TABLE_SCAN_LONG_STAT_SUM | Total number of long table scans. |
ORSS_USER_CALLS_STAT_SUM | Total number of user calls. |
ORSS_PHYSICAL_READS_STAT_SUM | Total number of disk reads. |
ORSS_PWII_INSTANCE_ID | ID of the instance. |
ORSS_OPENS_AND_FETCHES_SUM | Total number of open and fetches. |
ORSS_PARENT_SHV | Name of the PL/SQL that ran the SQL statement. |
ORSS_MIN_PARALLEL_DEGREE_MIN | Minimum parallel degree used to run the statement. |
ORSS_MAX_PARALLEL_DEGREE_MAX | Maximum parallel degree used to run the statement. |
ORSS_RECEIVED_TIMESTAMP | Timestamp at which the row was loaded into the PMDB. |
ORSS_BUFFER_GETS_SUM | Total time spent getting buffers. |
ORSS_ROWS_PROCESSED_SUM | Total number of rows processed. |
ORSS_EXEC_NO_SUM | Total number of statement executions. |
ORSS_SQL_ID_MIN | Minimum Oracle's SQL ID. |
ORSS_HASH_VALUE_MIN | Minimum Oracle's hash value. |
ORSS_PLAN_HASH_VALUE | Oracle's plan hash value. |
ORSS_END_OF_FETCH_COUNT_SUM | Number of END OF FETCHs. |
ORSS_VERSION_COUNT_MAX | Number of versions. |
PW_ORFS_FILES_STATS_T
Stores performance statistics about datafiles per hour.
The _T
table summarizes the data per timeslice.
The _D
table summarizes the data per day.
The _W
table summarizes the data per week.
The _M
table summarizes the data per month.
(N <table_name>)
means normalized, the actual name can be retrieved from the <table_name>
.
Column Name | Column Description |
---|---|
ORFS_UNIT_ID | The ID of the unit caching the I/O wait (N PW_ORUT_UNIT_NAME_N ). |
ORFS_DEVICE_ID | The ID of the device caching the I/O wait (N PW_ORDV_DEVICE_NAME_N ). |
ORFS_FILE_ID | The ID of the Oracle file caching the I/O wait (N PW_ORFL_FILE_NAME_N ). |
ORFS_PDEV_ID | Physical device name (N PW_ORPV_PDEV_NAME_N ). |
ORFS_FS_ID | File system name (N PW_ORFY_FS_NAME_N ). |
ORFS_LV_ID | Logical volume name (N PW_ORLV_LV_NAME_N ). |
ORFS_TIMESTAMP | The time when the session was sampled. |
ORFS_OBJECT_NAME_ID | Object name ID (N PW_OROB_OBJECT_NAME_N ). |
ORFS_OBJECT_ID | Object ID. |
ORFS_OBJECT_OWNER_ID | ID of the object owner (N PW_OROO_OBJECT_OWNER_NAME_N ). |
ORFS_NAMESPACE_ID | ID of the translation table (PW_ORNN_NAMESPACE_NAME ). |
ORFS_MINUTES_COUNT_SUM | Total amount of minutes summed in that row. |
ORFS_PWHG_ID | The hour group ID that matches the time sampled. |
ORFS_DIRECT_IO_SUM | Total time spend in waiting for a direct I/O. |
ORFS_SCATTERED_IO_SUM | Total time spend in waiting for a scattered I/O. |
ORFS_SEQ_IO_SUM | Total time spend in waiting for a sequential I/O. |
ORFS_OTHER_SUM | Total time spend in waiting for an I/O that is not scattered/sequential/direct. |
ORFS_PWII_INSTANCE_ID | The ID of the instance. |
ORFS_RECEIVED_TIMESTAMP | The timestamp that the row was loaded into the PW. |
ORFS_STORAGE_TYPE | Type of storage. |
ORFS_SUB_OBJECT_NAME_ID | ID of the sub object name (N PW_OROB_OBJECT_NAME_N ). |
ORFS_IN_ORACLE_TIME_SUM | Total time spent in Oracle. |
ORFS_ROW_LOCK_SUM | Total time spent in waiting for a row lock. |
ORFS_TABLE_LOCK_SUM | Total time spent in waiting for a table lock. |
ORFS_BUFFER_WAIT_SUM | Total time spent in waiting for a buffer wait. |
ORFS_RAC_OPS_WAIT_TIME_SUM | The time Oracle spent waiting for RAC or OPS synchronization. |
PW_ORST_STATEMENTS
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_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.