Page History
...
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_ | ORSA_ | ORSA_ | ORSA_ | ORSA_ | ORSA_ | ORSA_ | ORSA_ | ORSA_ | 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.
Info |
---|
The The The The
|
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.