Page History
...
| Column Name | Column Description |
|---|---|
ORSE_PWII_INSTANCE_ID | ID of the instance. |
ORSE_TIMESTAMP | The date of the sampling. |
ORSE_EVENT_ID | Event name (N PW_OREI_EVENT_N). |
ORSE_TOTAL_WAITS_SUM | Total number of waits for this event. |
ORSE_TOTAL_TIMEOUTS_SUM | Total number of timeouts for this event. |
ORSE_TIME_WAITED_SUM | Total amount of time waited for this event (, in hundredths of a second). |
ORSE_MINUTES_COUNT_SUM | Total amount of minutes summed in the row. |
ORSE_PWHG_ID | The hour group ID that matches the time sampled. |
ORSE_RECEIVED_TIMESTAMP | The timestamp that the statement was received. |
...
This table contains information about execution plan steps and slightly differs from the PLAN_TABLE. Information comes from Oracle.
...
| Column Name | Column Description |
|---|---|
ORPN_PLANID | Statement plan ID. |
ORPN_OPSEQ | Operation sequence, as ID (in plan_table). |
ORPN_INSTANCE_ID | Instance ID. |
ORPN_OPLEVEL | Indentation level of the step in the tree. |
ORPN_OPTYPE | Operation type number. (Not in plan_table) |
ORPN_OPCODE | Operation code number. (Not in plan_table) |
ORPN_OPTEXT | Not used. |
ORPN_OPERATION | Operation options from plan_table. |
ORPN_VIEW_EXISTS | Indicates whether an object is access using a view. (Not in plan_table) |
ORPN_OBJ_OWN | Object's owner. The same as OBJECT_OWNER in plan_table. |
ORPN_OBJ_NAME | Object's name. The same as OBJECT_NAME in plan_table. |
ORPN_OBJ_NODE | Database link used to reference the object. The same as OBJECT_NODE in plan_table. |
ORPN_BS_OBJ_OWN | Base object owner (owner of table of index). (Not in plan_table) |
ORPN_BS_OBJ_NAME | Base object name (table name of index). (Not in plan_table). |
ORPN_INDONLY | Is this an “Index Only” "Index Only" operation (Not in plan_table)? |
ORPN_ONJ_INS | For table/views/direct indexes. The For indexes. The |
ORPN_ORG_OBJ_INS | Sequential number of the table in the statement text. (Not in plan_table) |
ORPN_PARENT_ID | The same as PARENT_ID in plan_table. |
ORPN_STEPNO | The step number in Oracle's way of going through the plan. (Not in plan_table) |
ORPN_STEP_SNS | A list of all steps’ sons of this step (Not in plan_table). |
ORPN_OPTI | The current mode of the optimizer. The same as OPTIMIZER in plan_table. |
ORPN_COSTI | Cost of the step. The same as COST in plan_table. |
ORPN_CARDI | The number of rows accessed by the operation of the step. The same as CARDINALITY in plan_table. |
ORPN_BYTI | Number of bytes accessed by the operation. The same as BYTES in plan_table. |
ORPN_PART_START | The start position of a range of accessed partitions. The same as PARTITION_START in plan_table. |
ORPN_PART_STOP | The stop position of a range of accessed partitions. The same as PARTITION_STOP in plan_table. |
...
| Column Name | Column Description |
|---|---|
ORLI_PWII_INSTANCE_ID | ID of the database. |
ORLI_TIMESTAMP | Timestamp of the sampling. |
ORLI_NAMESPACE_ID | The library cache namespace (N PW_ORNS_NAMESPACE_N). |
ORLI_GETS_SUM | Total number of times a lock was requested for objects of this namespace. |
ORLI_GETHITS_SUM | Total number of times an object’s object's handle was found in the memory. |
ORLI_GETHITRATIO_SUM | Ratio of GETHITS to GETS. |
ORLI_PINS_SUM | Total number of times a PIN was requested for objects of this namespace. |
ORLI_PINHITS_SUM | Total number of times all of the metadata pieces of the library object were found in the memory. |
ORLI_PINHITRATIO_SUM | Ratio of PINHITS to PINS. |
ORLI_RELOADS_SUM | Any PIN of an object that is not the first PIN performed since the object handle was created and that requires loading the object from disk. |
ORLI_INVALIDATIONS_SUM | Total number of times objects in this namespace were marked invalid, because a dependent object was modified. |
ORLI_DLM_LOCK_REQUESTS_SUM | Total number of GET requests to lock instance locks. |
ORLI_DLM_PIN_REQUESTS_SUM | Total number of PIN requests to lock instance locks. |
ORLI_DLM_PIN_RELEASES_SUM | Total number of release requests for PIN instance locks. |
ORLI_DLM_INVALID_REQUESTS_SUM | Total number of GET requests for invalidation of instance locks. |
ORLI_DLM_INVALIDATIONS_SUM | Total number of invalidation pings received from other instances. |
ORLI_MINUTES_COUNT_SUM | Total amount of minutes summed in the row. |
ORLI_PWHG_ID | The hour group ID that matches the sampled time. |
ORLI_RECEIVED_TIMESTAMP | The timestamp that the row was loaded into the PW. |
...
| Info |
|---|
The The The The
|
| Column Name | Column Description |
|---|---|
OROS_PWII_INSTANCE_ID | ID of the instance database. |
OROS_TIMESTAMP | The time the statement was inserted. |
OROS_NAMESPACE_ID | ID of the namespace. |
OROS_OBJECT_NAME_ID | ID of the object name (N PW_OROB_OBJECT_NAME_N). |
OROS_OBJECT_ID | ID of the object. |
OROS_OBJECT_OWNER_ID | ID of the owner of the object (N PW_OROO_OBJECT_OWNER_NAME_N). |
OROS_PROGRAM_ID | ID of the program, making the Oracle connection (N PW_ORPR_PROGRAM_NAME_N). |
OROS_USER_ID | ID of the Oracle schema to which the program connected (N PW_ORUS_USER_NAME_N). |
OROS_HOST_USER_ID | ID of the host user running the program (N PW_ORHU_HOST_USER_NAME_N). |
OROS_MACHINE_ID | ID of the OS machine running the program (N PW_ORMC_MACHINE_NAME_N). |
OROS_MODULE_ID | ID of the session's action as set by calling dbms_application_info.set_module (N PW_ORMD_MODULE_NAME_N). |
OROS_ACTION_ID | ID of the session's action as set by calling dbms_application_info.set_action (N PW_ORAT_ACTION_NAME_N). |
OROS_WORK_TYPE | The ERP work type. |
OROS_INTERPOINT_MODE | Interpoint mode - OA/SAP/PS. |
OROS_DIRECT_IO_SUM | Total time spent in waiting for a direct I/O. |
OROS_SCATTERED_IO_SUM | Total time spent in waiting for a scattered I/O. |
OROS_SEQ_IO_SUM | Total time spent in waiting for a sequential I/O. |
OROS_OTHER_SUM | Total time spent in waiting for an I/O that is not scattered/sequential/direct. |
OROS_ROW_LOCK_SUM | Total time spent in waiting for a row lock. |
OROS_BUFFER_WAIT_SUM | Total time spent in waiting for a buffer wait. |
OROS_MINUTES_COUNT_SUM | Total amount of minutes summed in the row. |
OROS_PWHG_ID | The hour group ID that matches the sampled time. |
OROS_RECEIVED_TIMESTAMP | The timestamp that the row was received. |
OROS_IN_ORACLE_TIME_SUM | Total time spent in Oracle. |
OROS_TABLE_LOCK_SUM | Total time spent in waiting for a table lock. |
OROS_SUB_OBJECT_NAME_ID | ID of the sub object name (N PW_OROB_OBJECT_NAME_N). |
OROS_RAC_OPS_WAIT_TIME_SUM | The time Oracle spent waiting for RAC or OPS synchronization. |
PW_ORSO_STMT_OBJ_STATS_T
Stores object statistics.
| Info |
|---|
The The The The
|
| Column Name | Column Description |
|---|---|
ORSO_PWII_INSTANCE_ID | ID of the instance database. |
ORSO_TIMESTAMP | The time the statement was inserted. |
ORSO_NAMESPACE_ID | ID of the namespace. |
ORSO_OBJECT_NAME_ID | ID of the object name (N PW_OROB_OBJECT_NAME_N). |
ORSO_OBJECT_ID | ID of the object. |
ORSO_OBJECT_OWNER_ID | ID of the owner of the object (N PW_OROO_OBJECT_OWNER_NAME_N). |
ORSO_PROGRAM_ID | ID of the program, making the Oracle connection (N PW_ORPR_PROGRAM_NAME_N) |
ORSO_USER_ID | ID of the Oracle schema to which the program connected (N PW_ORUS_USER_NAME_N). |
ORSO_HOST_USER_ID | ID of the host user running the program (N PW_ORHU_HOST_USER_NAME_N). |
ORSO_MACHINE_ID | ID of the OS machine running the program (N PW_ORMC_MACHINE_NAME_N). |
ORSO_MODULE_ID | ID of the session’s action as set by calling dbms_application_info.set_module (N PW_ORMD_MODULE_NAME_N). |
ORSO_ACTION_ID | ID of the session’s action as set by calling dbms_application_info.set_action (N PW_ORAT_ACTION_NAME_N). |
ORSO_WORK_TYPE | The ERP work type. |
ORSO_INTERPOINT_MODE | Interpoint mode - OA/SAP/PS. |
ORSO_DIRECT_IO_SUM | Total time spent in waiting for a direct I/O. |
ORSO_SCATTERED_IO_SUM | Total time spent in waiting for a scattered I/O. |
ORSO_SEQ_IO_SUM | Total time spent in waiting for a sequential I/O. |
ORSO_OTHER_SUM | Total time spent in waiting for an I/O that is not scattered/sequential/direct. |
| ORSO_RECEIVED_TIMESTAMP | Total time spent in waiting for a buffer wait. |
ORSO_SHV | The statement hash value. |
ORSO_PARENT_SHV | The name of the PL/SQL running the SQL statement. |
ORSO_FILE_ID | File name (N PW_ORFI_FILE_N). |
ORSO_PDEV_ID | Physical device name (N PW_ORPV_PDEV_NAME_N). |
ORSO_FS_ID | File system name (N PW_ORFY_FS_NAME_N). |
ORSO_LV_ID | Logical volume name (N PW_ORLV_LV_NAME_N). |
ORSO_STORAGE_TYPE | Type of storage. |
ORSO_UNIT_ID | ID of the storage unit. |
ORSO_DEVICE_ID | ID of the storage device. |
ORSO_IN_ORACLE_TIME_SUM | Total time spent in Oracle. |
ORSO_TABLE_LOCK_SUM | Total time spent in table locks. |
ORSO_SQL_ID_MIN | Minimum Oracle's SQL ID. |
ORSO_HASH_VALUE_MIN | Minimum Oracle's hash value. |
ORSO_PLAN_HASH_VALUE | Oracle's plan hash value. |
ORSO_SUB_OBJECT_NAME_ID | ID of the sub object name (N PW_OROB_OBJECT_NAME_N). |
ORSO_RAC_OPS_WAIT_TIME_SUM | The time Oracle spent waiting for RAC or OPS synchronization. |