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_ | 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_ | |
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 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.
...