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_ | |
ORSA_ | |
ORSA_ | |
ORSA_ | |
ORSA_ | |
ORSA_ | |
ORSA_ | |
ORSA_ | |
ORSA_ | |
ORSA_ |
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 OK.
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_TIM E_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_RECIEVED_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.