Page History
...
| 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. |
PW_ORBV_STMT_BIND_VALUES_T
Holds information on bind values sampled from the monitored instance. Each row represents one bind value, a group of rows represent a set of one or more binds which were used by a statement during a single statement execution.
| Column Name | Column Description |
|---|---|
ORBV_PWII_INSTANCE_ID | ID of the instance database. |
ORBV_TIMESTAMP | The time the statement was inserted. |
ORBV_MINUTES_COUNT_SUM | Total amount of minutes summed in the row. |
ORBV_PWHG_ID | The hour group ID that matches the sampled time. |
ORBV_RECEIVED_TIMESTAMP | The timestamp that the row was received. |
ORBV_SHV | Name of the SQL statement. |
ORBV_HASH_VALUE | Oracle's hash value. |
ORBV_SQL_ID | SQL identifier of the parent cursor in the library cache. |
ORBV_CHILD_ADDRESS | Address of the parent cursor. |
ORBV_BIND_NAME | Name of the bind variable. |
ORBV_POSITION | Position of the bind variable in the SQL statement. |
ORBV_DUP_POSITION | If the binding is performed by name and the bind variable is duplicated, then this column gives the position of the primary bind variable. |
ORBV_DATATYPE | Internal identifier for the bind datatype. |
ORBV_DATATYPE_STRING | Textual representation of the bind datatype. |
ORBV_PRECISION | Precision (for numeric binds). |
ORBV_SCALE | Scale (for numeric binds). |
ORBV_MAX_LENGTH | Maximum bind length. |
ORBV_WAS_CAPTURED | Indicates whether the bind value was captured (YES) or not (NO). |
ORBV_LAST_CAPTURED | Date when the bind value was captured. Bind values are captured when SQL statements are executed. To limit the overhead, binds are captured at most every 15 minutes for a given cursor. |
ORBV_VALUE_STRING | Value of the bind represented as a string. |
ORBV_ECOST | Estimated cost for SQL statement with this binds set. |
ORBV_EPLAN_HASH_VALUE | Estimated plan hash value for SQL statement with this binds set. |
ORBV_COST_ESTIMATION_DATE | Cost and plan hash value of the estimation date. |
PS_ORFG_FINDINGS
Describes the findings displayed in the SQL workspace and in the Dashboard findings section. Each row describes one finding and includes its text, its type and misc. display info (such as icon shape).
| Column Name | Column Description |
|---|---|
ORFG_FINDING_ID | The finding ID. |
ORFG_FINDING_DESC | The finding description. |
ORFG_FINDING_TYPE | The finding type (STMT, STMT-OBJ, INSTANCE). |
ORFG_FINDING_ICON_NUMBER | The default launch icon number. |
ORFG_FINDING_SUB_STATE | The sub-state of this finding. |
PW_ORCT_CAPACITY_TRACK_D
Contains overtime data of the tablespace capacity.
| Column Name | Column Description |
|---|---|
ORCT_PWII_INSTANCE_ID | ID of the Oracle Server instance. |
ORCT_TIMESTAMP | Date and time the statistic was sampled. |
ORCT_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
ORCT_PWHG_ID | Hour group ID. |
ORCT_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
ORCT_TABLESPACE_ID | The tablespace to which the data refers. |
ORCT_DATAFILE_BYTES_AVG | Number of bytes in the datafiles. |
ORCT_FREE_SPACE_BYTES_AVG | Number of free bytes. |
ORCT_TABLE_BYTES_AVG | Number of bytes reserved for tables. |
ORCT_TABLE_OCCUPIED_BYTES_AVG | Number of bytes actually occupied by tables. |
ORCT_INDEX_BYTES_AVG | Number of bytes reserved for indexes. |
ORCT_INDEX_OCCUPIED_BYTES_AVG | Number of bytes actually occupied by indexes. |
PW_ORTA_TABLES_STATISTICS_D
Contains overtime data of table statistics.
| Column Name | Column Description |
|---|---|
ORTA_PWII_INSTANCE_ID | ID of the Oracle server instance. |
ORTA_TIMESTAMP | Date and time the statistic was sampled. |
ORTA_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
ORTA_PWHG_ID | Hour group ID. |
ORTA_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
ORTA_OWNER_ID | The table owner. |
ORTA_TABLE_ID | The table name. |
ORTA_EXTENTS_AVG | Number of extents for the table. |
ORTA_SEGMENT_BLOCKS_AVG | Number of used blocks for the table. |
ORTA_NUM_ROWS_AVG | Number of rows in the table. |
ORTA_BLOCKS_AVG | Number of block for the table. |
ORTA_EMPTY_BLOCKS_AVG | Number of empty blocks in the table. |
ORTA_AVG_SPACE_AVG | The average available free space in the table. |
ORTA_CHAIN_CNT_AVG | Number of chained rows in the table. |
ORTA_AVG_ROW_LEN_AVG | Average row length in the table. |
PW_ORIO_INDEXES_STATISTICS_D
Contains overtime data of index statistics.
| Column Name | Column Description |
|---|---|
ORIO_PWII_INSTANCE_ID | ID of the Oracle server instance. |
ORIO_TIMESTAMP | Date and time the statistic was sampled. |
ORIO_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
ORIO_PWHG_ID | Hour group ID. |
ORIO_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
ORIO_OWNER_ID | The index owner. |
ORIO_INDEX_ID | The index name. |
ORIO_TABLE_OWNER_ID | The indexed table owner. |
ORIO_TABLE_ID | The indexed table name. |
ORIO_BLEVEL_AVG | B-Tree level. |
ORIO_LEAF_BLOCKS_AVG | The number of leaf blocks in the index. |
ORIO_DISTINCT_KEYS_AVG | The number of distinct keys in the index. |
ORIO_AVG_LEAF_BLK_PER_KEY_AVG | The average number of leaf blocks per key. |
ORIO_AVG_DATA_BLK_PER_KEY_AVG | The average number of data blocks per key. |
ORIO_CLUSTERING_FACTOR_AVG | A measurement of the amount of (dis)order of the table this index is for. |
ORIO_NUM_ROWS_AVG | Number of rows in the indexed table. |
ORIO_SAMPLE_SIZE_AVG | The sample size used in analyzing this index. |