Versions Compared

Old Version 23

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 24

changes.mady.by.user Nadja Pollard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

The _H table summarizes the data per hour.

The _D table summarizes the data per day. 

The _W table summarizes the data per week.

The _M table summarizes the data per month.

(N <table_name>) means normalized, the actual name can be retrieved from the <table_name>.

Column NameColumn Description
OROT_PWII_INSTANCE_IDID of the database.
OROT_TIMESTAMPDate of the sampling.
OROT_STAT_NAME_IDName of the statistic counter. (N PW_ORTE_STAT_NAME_N)
OROT_OSSTAT_IDStatistics ID as it appeared in v$osstat.
OROT_VALUE_SUMTotal value of the statistic counter.
OROT_MINUTES_COUNT_SUMTotal amount of minutes summed in the row.
OROT_PWHG_IDThe hour group ID that matches the sampled time.
OROT_RECEIVED_TIMESTAMPThe 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 NameColumn Description
ORED_SM_PROBLEM_IDThe unique problem that this effect checks.
ORED_SM_EFFECT_IDThe ID of this effect.
ORED_SM_EFFECT_CLASSThe java class handling this effect in the system.
ORED_SM_EFFECT_PARAMAn optional parameter to the effect class, if the class handles system statistics then the parameter says which specific statistic is used.
ORED_SM_EFFECT_THREASHOLDThe threshold the effect needs to cross to be considered as real effect on system performance.
ORED_SM_COLLECTOR_KEYThe collected data pointer we need to access.
ORED_SM_ANALYSIS_IDThe 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 NameColumn Description
ORCC_SM_INSTANCE_IDPart of the key because each instance is collected separately.
ORCC_SM_DATA_SOURCEThe collector_name from data_collection table.
ORCC_SM_COLLECTION_TIMEThe start or end collection time for this run.
ORCC_SM_COLLECTION_STATUSIndication 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 _T table summarizes the data per timeslice.

The _D table summarizes the data per day. 

The _W table summarizes the data per week.

The _M table summarizes the data per month.

Column NameColumn Description
ORTF_PWII_INSTANCE_IDID of the instance in which the statement was executed.
ORTF_TIMESTAMPThe time of the change.
ORTF_EVENT_NAMEName of the event.
ORTF_P1Parameter 1.
ORTF_P2Parameter 2.
ORTF_P3Parameter 3.
ORTF_MINUTES_COUNT_SUMTotal amount of minutes summed in the row.
ORTF_PWHG_IDThe ID of the database.
ORTF_RECEIVED_TIMESTAMPThe timestamp that the row was loaded into the PW.
ORTF_COUNTER_SUMIn-Oracle time of the process.

PW_ORTB_SMARTUNE_BG_T

Stores detailed information on the background sessions and their Oracle time.

Info

The _T table summarizes the data per timeslice.

The _D table summarizes the data per day. 

The _W table summarizes the data per week.

The _M table summarizes the data per month.

Column NameColumn Description
ORTB_PWII_INSTANCE_IDID of the instance, in which the statement was executed.
ORTB_TIMESTAMPThe time of the change.
ORTB_EVENT_NAMEName of the event.
ORTB_P1Parameter 1.
ORTB_P2Parameter 2.
ORTB_BG_PROCESSName of the background process.
ORTB_MINUTES_COUNT_SUMTotal amount of minutes summed in the row.
ORTB_PWHG_IDThe ID of the database.
ORTB_RECEIVED_TIMESTAMPThe timestamp that the row was loaded into the PW.
ORTB_COUNTER_SUMIn-Oracle time of the process.

PW_ORPN_STATEMENT_PLAN_STEPS

...

Info

The column description can contain the following additional specifications:

  • in plan_table The data in the column comes from Oracle's Execution plan.
  • not in plan_table The data is a result of our plan processing.
Column NameColumn Description
ORPN_PLANIDStatement plan ID.
ORPN_OPSEQOperation sequence, as ID (in plan_table).
ORPN_INSTANCE_IDInstance ID.
ORPN_OPLEVELIndentation level of the step in the tree.
ORPN_OPTYPEOperation type number. (Not in plan_table)
ORPN_OPCODEOperation code number. (Not in plan_table)
ORPN_OPTEXTNot used.
ORPN_OPERATIONOperation options from plan_table.
ORPN_VIEW_EXISTSIndicates whether an object is access using a view. (Not in plan_table)
ORPN_OBJ_OWNObject's owner. The same as OBJECT_OWNER in plan_table.
ORPN_OBJ_NAMEObject's name. The same as OBJECT_NAME in plan_table.
ORPN_OBJ_NODEDatabase link used to reference the object. The same as OBJECT_NODE in plan_table.
ORPN_BS_OBJ_OWNBase object owner (owner of table of index). (Not in plan_table)
ORPN_BS_OBJ_NAMEBase object name (table name of index). (Not in plan_table).
ORPN_INDONLYIs this an “Index Only” operation (Not in plan_table)?
ORPN_ONJ_INS

For table/views/direct indexes. The object_instance from plan_table.

For indexes.  The object_instance of the parent table.

ORPN_ORG_OBJ_INSSequential number of the table in the statement text. (Not in plan_table)
ORPN_PARENT_IDThe same as PARENT_ID in plan_table.
ORPN_STEPNOThe step number in Oracle's way of going through the plan. (Not in plan_table)
ORPN_STEP_SNSA list of all steps’ sons of this step (Not in plan_table).
ORPN_OPTIThe current mode of the optimizer. The same as OPTIMIZER in plan_table.
ORPN_COSTICost of the step. The same as COST in plan_table.
ORPN_CARDIThe number of rows accessed by the operation of the step. The same as CARDINALITY in plan_table.
ORPN_BYTINumber of bytes accessed by the operation. The same as BYTES in plan_table.
ORPN_PART_STARTThe start position of a range of accessed partitions. The same as PARTITION_START in plan_table.
ORPN_PART_STOPThe 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 NameColumn Description
ORPL_PLANIDUnique key (sequence).
ORPL_STATEMENT_IDFK to STATEMENT_INFO.STATEMENT_ID.
ORPL_INSTANCE_IDDe-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_PTIMEThe time when this plan was inserted.
ORPL_LAST_PNAME

Last explain time. Equals to FIRST_PTIME when the plan is new.

The difference between LAST_PNAME and FIRST_PTIME shows how long the plan remained the same.

ORPL_IS_LAST_EXPLAINED

Is this the result of last explain for the statement? The values are:

  • N No
  • Y  Yes
  • T This is a temporary plan (of expanded statement)
ORPL_PLAN_HASHHash for the statement's plan.
ORPL_STEPS_PLANIDThis 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
  • 0 Without parsing
  • 1 With parsing
ORPL_COSTOverall cost of the statement, as sampled by explain.
ORPL_EXPLAINS_COUNTFor 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 _H table summarizes the data per hour.

The _D table summarizes the data per day. 

The _W table summarizes the data per week.

The _M table summarizes the data per month.

(N <table_name>) means normalized, the actual name can be retrieved from the <table_name>.

Column NameColumn Description
ORLI_PWII_INSTANCE_IDID of the database.
ORLI_TIMESTAMPTimestamp of the sampling.
ORLI_NAMESPACE_IDThe library cache namespace (N PW_ORNS_NAMESPACE_N).
ORLI_GETS_SUMTotal number of times a lock was requested for objects of this namespace.
ORLI_GETHITS_SUMTotal number of times an object’s handle was found in the memory.
ORLI_GETHITRATIO_SUMRatio of GETHITS to GETS.
ORLI_PINS_SUMTotal number of times a PIN was requested for objects of this namespace.
ORLI_PINHITS_SUMTotal number of times all of the metadata pieces of the library object were found in the memory.
ORLI_PINHITRATIO_SUMRatio of PINHITS to PINS.
ORLI_RELOADS_SUMAny 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_SUMTotal number of times objects in this namespace were marked invalid, because a dependent object was modified.
ORLI_DLM_LOCK_REQUESTS_SUMTotal number of GET requests to lock instance locks.
ORLI_DLM_PIN_REQUESTS_SUMTotal number of PIN requests to lock instance locks.
ORLI_DLM_PIN_RELEASES_SUMTotal number of release requests for PIN instance locks.
ORLI_DLM_INVALID_REQUESTS_SUMTotal number of GET requests for invalidation of instance locks.
ORLI_DLM_INVALIDATIONS_SUMTotal number of invalidation pings received from other instances.
ORLI_MINUTES_COUNT_SUMTotal amount of minutes summed in the row.
ORLI_PWHG_IDThe hour group ID that matches the sampled time.
ORLI_RECEIVED_TIMESTAMPThe timestamp that the row was loaded into the PW.







Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 | 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/precise/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 |  
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
  | 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse