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