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_ | |
ORFS_ | |
ORFS_ | |
ORFS_ | |
ORFS_ | |
ORFS_ | |
ORFS_ | |
ORFS_ | |
ORFS_ | |
ORFS_ | |
ORFS_ |
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_RECIEVED_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_S UM The time Oracle spent waiting for RAC or OPS synchronization.