Page History
...
| 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). |
...