Page History
...
The Overview displays general information about the selected entity and a table listing the In Oracle sub-states for this entity. See “In Oracle” on page 36 Wait States - In Oracle.
The following table describes what is displayed in the overview.
...
The In Oracle view displays a stacked bar graph on the In Oracle resource consumption over time, for the selected time frame, broken down into the In Oracle wait states. See “In Oracle” on page 36 Wait States - In Oracle.
About the overall activity view
...
If bind variables were captured for a statement, a link is displayed that launches to the Bind Variables tab in the SQL tab, with the statement in context, to run a statement with the actual bind variables that are being used. If you drill down to a statement from an execution plan entity, and execution plans were captured for the statement, a link is displayed that launches to the All Plans tab in the SQL tab, with the statement in context. See “In Oracle” on page 36 and Wait States - In Oracle and “About the Bind Variables view” on page 148.
...
The In Oracle view displays a stacked bar graph in the Activity tab on the In Oracle resource consumption over time, for the selected time frame, broken down into the In Oracle wait states. See “In Oracle” on page 36 Wait States - In Oracle.
About the overall activity of a statement or PL/SQL
...
The Overview, in the Activity tab, displays general information about the selected entity, a table that lists the In Oracle sub-states for this entity, and the complete SQL text of the SQL statement. See “In Oracle” on page 36 Wait States - In Oracle.
The following table describes the information displayed for an execution plan.
...
The In Oracle view, in the Activity tab, displays a stacked bar graph on the In Oracle resource consumption for the execution plan, over time, broken down into the In Oracle wait states. See “In Oracle” on page 36 Wait States - In Oracle.
About the overall activity view of an execution plan
...
The In Oracle view, in the Activity tab, displays a stacked bar graph on the In Oracle resource consumption over time, for the selected time frame, broken down into the In Oracle wait states. Particularly important for an object is the amount of time spent in I/O wait, Internal Lock wait, and Application Lock wait, that is how well cached the object is. See “In Oracle” on page 36 Wait States - In Oracle.
About the dictionary view of an object
...
The Overview, in the Activity tab, displays general information about the Extended Collection for the specified time frame and a table that lists the In Oracle sub-states for this entity. See “In Oracle” on page 36 Wait States - In Oracle.
The following table describes how the general information for an extended collection is structured.
...
The In Oracle view, in the Activity tab, displays a stacked bar graph on the In Oracle resource consumption over time, for the selected time frame, broken down into the In Oracle wait states. See “In Oracle” on page 36 Wait States - In Oracle.
About the overall activity view of an extended collection
...
The Overview, in the Activity tab, displays general information about the Session (in an Extended Collection) or Recent Session for the specified time frame and a table listing the In Oracle sub-states for this entity (for details on these sub-states, see See “In Oracle” on page 36 Wait States - In Oracle.).
The following table describes how the general information for a session or recent session is structured.
...
The In Oracle view, in the Activity tab, displays a stacked bar graph on the In Oracle resource consumption over time, for the selected time frame, broken down into the In Oracle wait states. See “In Oracle” on page 36 Wait States - In Oracle.
About the overall activity of a session or recent session
...
The Overview, in the Activity tab, displays a table listing the In Oracle sub-states for this storage device. See “In Oracle” on page 36 Wait States - In Oracle.
The following table describes the In Oracle (Sum.) table for an extended collection.
...