Page History
...
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 | |
OROS_TIMESTAMP | |
OROS_NAMESPACE_ID | |
OROS_OBJECT_NAME_ID | |