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. |
...
Stores system statistics information.
| Column Name | Column Description |
|---|---|
ORSY_PWII_INSTANCE_ID | ID of the database. |
ORSY_TMESTAMP | Date of the sampling. |
ORSY_STATISTIC_NUM | Number of the statistic counter. Note that statistic numbers are not guaranteed to remain constant from one release to another. Therefore you should rely on the statistic name, rather than its number in your applications. |
ORSY_STATISTIC_ID | Name of the statistic counter. ( |
ORSY_CLASS | Number representing one or more statistics class. The following class numbers are additive:
|
ORSY_VALUE_SUM | Value of the statistic counter. |
ORSY_MINUTES_COUNT_SUM | Total amount of minutes summed in the row. |
ORSY_PWHG_ID | The hour group ID that matches the sampled time. |
ORSY_RECEIVED_TIMESTAMP | The timestamp that the row was loaded into the PW. |
PW_ORPG_V_PCASTAT_H
Stores detailed information on the program global area (PGA_. The data is collected for databases of Precise 9.2 and later.
| Info |
|---|
The The The The
|
| Column Name | Column Description |
|---|---|
ORPG_PWII_INSTANCE_ID | ID of the database. |
ORPG_TIMESTAMP | Date of the sampling. |
ORPG_NAME_ID | Name of the statistic counter. (N PW_ORNE_NAMEPGA_N) |
ORPG_VALUE_AVG | Average value of the statistic counter. |
ORPG_VALUE_SUM | Total value of the statistic counter. |
ORPG_MINUTES_COUNT_SUM | Total amount of minutes summed in the row. |
ORPG_PWHG_ID | The hour group ID that matches the sampled time. |
ORPG_RECEIVED_TIMESTAMP | The timestamp that the row was loaded into the PW. |
PW_ORTM_V_SYS_TIME_MODEL_H
...
| Info |
|---|
The The The The
|
| Column Name | Column Description |
|---|---|
ORTM_PWII_INSTANCE_ID | ID of the database. |
ORTM_TIMESTAMP | Date of the sampling. |
ORTM_STAT_NAME_ID | Name of the statistic counter. (N PW_ORTO_STAT_NAME_N) |
ORTM_STAT_ID | ID of the statistic counter. |
ORTM_VALUE_SUM | Total value of the statistic counter. |
ORTM_MINUTES_COUNT_SUM | Total amount of minutes summed in the row. |
ORTM_PWHG_ID | The hour group ID that matches the sampled time. |
ORTM_RECEIVED_TIMESTAMP | The timestamp that the row was loaded into the PW. |
PW_OROT_V_OSSTAT_H
Stores detailed information on the database operating system utilization, such as CPU and memory usage. The data is collected for databases of version 10 and higher.
| Info |
|---|
The The The The
|
| Column Name | Column Description |
|---|---|
OROT_PWII_INSTANCE_ID | ID of the database. |
OROT_TIMESTAMP | Date of the sampling. |
OROT_STAT_NAME_ID | Name of the statistic counter. (N PW_ORTE_STAT_NAME_N) |
OROT_OSSTAT_ID | Statistics ID as it appeared in v$osstat. |
OROT_VALUE_SUM | Total value of the statistic counter. |
OROT_MINUTES_COUNT_SUM | Total amount of minutes summed in the row. |
OROT_PWHG_ID | The hour group ID that matches the sampled time. |
OROT_RECEIVED_TIMESTAMP | The timestamp that the row was loaded into the PW. |
PS_ORED_SM_EFFECT_DEFINITION
Stores detailed information on the effects identified problematic opportunities have on the system performance.
| Column Name | Column Description |
|---|---|
ORED_SM_PROBLEM_ID | The unique problem that this effect checks. |
ORED_SM_EFFECT_ID | The ID of this effect. |
ORED_SM_EFFECT_CLASS | The java class handling this effect in the system. |
ORED_SM_EFFECT_PARAM | An optional parameter to the effect class, if the class handles system statistics then the parameter says which specific statistic is used. |
ORED_SM_EFFECT_THREASHOLD | The threshold the effect needs to cross to be considered as real effect on system performance. |
ORED_SM_COLLECTOR_KEY | The collected data pointer we need to access. |
ORED_SM_ANALYSIS_ID | The ID indicating which data to store for the GUI, from the analysis_definition table. |
PS_ORCC_SM_COLLECTION_CTRL
This is a control table to store history for the collection table.
| Column Name | Column Description |
|---|---|
ORCC_SM_INSTANCE_ID | Part of the key because each instance is collected separately. |
ORCC_SM_DATA_SOURCE | The collector_name from data_collection table. |
ORCC_SM_COLLECTION_TIME | The start or end collection time for this run. |
ORCC_SM_COLLECTION_STATUS | Indication if the collection was successful or not. |
PW_ORTF_SMARTUNE_FG_T
Stores detailed information on the foreground sessions and their Oracle time.
| Info |
|---|
The The The The |
| Column Name | Column Description |
|---|---|
ORTF_PWII_INSTANCE_ID | ID of the instance in which the statement was executed. |
ORTF_TIMESTAMP | The time of the change. |
ORTF_EVENT_NAME | Name of the event. |
ORTF_P1 | Parameter 1. |
ORTF_P2 | Parameter 2. |
ORTF_P3 | Parameter 3. |
ORTF_MINUTES_COUNT_SUM | Total amount of minutes summed in the row. |
ORTF_PWHG_ID | The ID of the database. |
ORTF_RECEIVED_TIMESTAMP | The timestamp that the row was loaded into the PW. |
ORTF_COUNTER_SUM | In-Oracle time of the process. |
PW_ORTB_SMARTUNE_BG_T
Stores detailed information on the background sessions and their Oracle time.
| Info |
|---|
The The The The |
| Column Name | Column Description |
|---|---|
ORTB_PWII_INSTANCE_ID | ID of the instance, in which the statement was executed. |
ORTB_TIMESTAMP | The time of the change. |
ORTB_EVENT_NAME | Name of the event. |
ORTB_P1 | Parameter 1. |
ORTB_P2 | Parameter 2. |
ORTB_BG_PROCESS | Name of the background process. |
ORTB_MINUTES_COUNT_SUM | Total amount of minutes summed in the row. |
ORTB_PWHG_ID | The ID of the database. |
ORTB_RECEIVED_TIMESTAMP | The timestamp that the row was loaded into the PW. |
ORTB_COUNTER_SUM | In-Oracle time of the process. |
PW_ORPN_STATEMENT_PLAN_STEPS
This table contains information about execution plan steps and slightly differs from the PLAN_TABLE. Information comes from Oracle.
| Info |
|---|
The column description can contain the following additional specifications:
|
| 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" 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 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. |
PS_ORPL_STATEMENT_PLAN
This table contains information about expressions performed on statements, like explain time, cost, explain error, and so on.
| Column Name | Column Description |
|---|---|
ORPL_PLANID | Unique key (sequence). |
ORPL_STATEMENT_ID | FK to STATEMENT_INFO.STATEMENT_ID. |
ORPL_INSTANCE_ID | De-normalization. This field is included for narrowing join results, when it is needed to get statement text by owner and name of object in the PLAN_OBJECTS. |
ORPL_FIRST_PTIME | The time when this plan was inserted. |
ORPL_LAST_PNAME | Last explain time. Equals to The difference between |
ORPL_IS_LAST_EXPLAINED | Is this the result of last explain for the statement? The values are:
|
ORPL_PLAN_HASH | Hash for the statement's plan. |
ORPL_STEPS_PLANID | This field links plan table to plan steps. It differs from PLAN_ID when only the cost changed. It equals PLAN_TABLE.PLAN_ID if the plan is changed. |
ORPL_EXPLAIN_TIME |
|
ORPL_COST | Overall cost of the statement, as sampled by explain. |
ORPL_EXPLAINS_COUNT | For future use. How many consequent explains of the statement resulted in this plan (the plan remained the same). |
PW_ORLI_V_LIBRARYCACHE_H
Stores statistics about the library cache performance and activity.
| Info |
|---|
The The The The
|
| 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 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. |
PW_OROS_OBJECTS_STATS_T
Stores object statistics.
| 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. |
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. |