Page History

...

The Current tab displays information on a selected entity and its associated entities. For example, if the selected entity is a Session, its associated entities are Statements. The selected entity is always reflected in the Tab heading, which serves as a point of orientation. The highest-level entity you can view information for in the Current tab is an Instance. You can view another instance by selecting it from the Instance list. When you open the Current tab from any tab, it always displays information on the instance level, even if the currently selected entity is not an instance.

About the Main area in the Current tab

The Main area shows comprehensive information on the selected entity. You can choose from several views to examine the entity from different angles. For example, if you are analyzing a session entity, you can focus exclusively on the data displayed in the overview, such as, In Oracle data (default), or choose to view the text for the current statement being run by the session.

About the Association area in the Current tab

The Association area provides corresponding information on the entities associated with the selected entity (displayed in the Main area). For example, you can associate with the Active Sessions related to the selected instance. The selection you make is reflected in the Association area only; the Main area remains unchanged. For some entities, tabs above the Association area enable you to view additional information. For example, the tabs displayed for a session entity are: General, In Oracle, and Connection. Clicking a tab displays different table columns with the same type of associated entities.

From the Association area, you can also drill down to another entity by clicking a table row. A drill down affects the entire tab. When you drill down to another entity, the Tab heading displays the new selection, the Main area displays information on the newly selected entity, and the Association area displays the entities associated with the selected entity.

For example, when you want to view information on a specific active session, from the Association controls, click Active Sessions. The Association area changes to display session-related information. Note that the Tab heading and the Main area remain unchanged.

If you want detailed information on an active session, in the Association area, click the row of the session that you want to view detailed information for. The Tab heading indicates the newly selected entity; the Main area displays In Oracle information on the session you drilled down to, and the Association area shows information on the statements associated with this session.
See “About Precise for Oracle tabs” on page 21 . See and “About the Dashboard tab” on page 43.

About examining entities in the Current tab

The Current tab displays information on different entities. This section provides an overview of all entities, their meaning, and their views.

The following entities can be examined in the Current tab:■    Instance

• Instance

...

• Session

...

• Statement

About the Instance entity

The Instance entity shows a summary of all sessions connected to Oracle during the last minute.

Getting an overview of current Instance activities

The Instance Overview displays information on the activity of the instance in the Main area. The following table describes the information displayed in the Instance Overview.

Table 4-1    Instance 1 Instance Overview
Item    Description
Sessions    Displays

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

About associating an Instance with other entities

You can associate an Instance, in the Main area of the Current tab, with the following entities in the Association area:■    Current

• Current Sessions

...

• . A list of all sessions that were connected during the last minute.

...

• Active Sessions

...

• . A list of all sessions that were connected and spent some time executing In Oracle during the minute.

These lists of sessions are each divided into different sets of information, showing different aspects of the sessions. Each set is accessed by a tab.

The following table describes the information shown on Instance Association tabs.

Table 4-2    Instance 2 Instance Association tabsTab    Columns
General    Displays

...

...

...

...

...

...

...

...

...

...

...

...

In Oracle    Displays the following table columns:
■    Icon—Indicates the current sub-state.
■    Session ID—Session ID or number.
■    Oracle Process ID—OS-assigned process ID of the Oracle server process.
■    In Oracle—Bar chart showing the Oracle breakdown for the session.
■    Using CPU—In Oracle wait state.
■    I/O wait—In Oracle wait state.
■    Application Lock wait—In Oracle wait state.
■    Commit & Checkpoint wait—In Oracle wait state.
■    Communication wait—In Oracle wait state.
■    Internal Lock wait—In Oracle wait state.
■    Oracle Server wait—In Oracle wait state.
■    Operating System wait—In Oracle wait state.
■    RAC/OPS/Other wait—In Oracle wait state. See “In Oracle” on page 36.
Connection    Displays the following table columns:
■    Icon—Indicates the current sub-state.
■    Session ID—Session ID or number.
■    Oracle Process ID—The ID of the Oracle server process. This ID is assigned by the operating system.
■    Oracle Process Type—Any of the following: Dedicated: Indicates a multi-threaded server
Shared: Indicates a server that is not multi-threaded
Parallel: Indicates that the session is a sub-session of another session
■    Connect Time—The date and time that the session got connected to Oracle.
■    Work Type—Group of Oracle activities. Only relevant when an Interpoint is installed.
See “About the Dashboard tab” on page 43.
■    ERP—Indicates the kind of Interpoint that is used. Can be OA (Oracle Applications), SAP, PS (PeopleSoft), or SBL (Siebel). If no Interpoint is installed, N/A is displayed.
■    Host User—The name of the host user. The information in this column is derived from Oracle's v$session table.
■    User—The name of the user. The information in this column is derived from Oracle's v$session table.
■    Program—The name of the program. The information in this column is derived from Oracle's v$session table.
■    Machine—The name of the machine. The information in this column is derived from Oracle's v$session table.
■    Module—The name of the module. The information in this column is derived from Oracle's v$session table.
■    Action—The name of the action. The information in this column is derived from Oracle's v$session table.
■    Terminal—The terminal name of the operating system. The information in this column is derived from
Oracle's v$session table.
■    Status—Status of the session. See “In Oracle” on page 36.


Note: Precise for Oracle retrieves the displayed information from Oracle's V$SESSION table. If this table does not contain relevant data for a specific cell in the Association table, this cell is not populated with data.

By clicking a row in the Association table, you can drill down to the specific session. See “About the Session entity” on page 56.

About the Kill Session process
The Kill Session process is executed by the Kill Session button. This button enables you to kill the selected session. You can instruct Oracle to execute this command immediately (using the Oracle Alter System Kill Session Immediate command) or during the time of less activity (using the Oracle Alter System Kill Session command).
To perform the Kill Session during the time of less activity

1    On the general tab of the Instance Association, select the session that needs to be killed.

2    Click Kill Session.

3    In the dialog, insert the Oracle DBA user name and password.

4    Click OK.
To perform the Kill Session immediately

1    On the general tab of the Instance Association, select the session that needs to be killed.

2    Click Kill Session.


3    In the dialog, insert the Oracle DBA user name and password.

4    Mark Kill immediately.

5    Click OK.


About the Session entity
The Session entity displays information on a single connection with Oracle.

About the overview of current and active sessions
The Session Overview displays general information on the session.
The following table describes the information displayed in a Session Overview.

Table 4-3    Session Overview

View area    Description
Session    Displays information for the following items:
■    Serial #—Oracle serial number, which, along with the session ID, uniquely identifies a session.
■    Connected Time—Time that the session connected to Oracle.
■    Duration—Duration of the session since it connected.
■    Sampling Start Time—Time that the Collector started sampling this session.
■    Sampling Duration—Duration that the Collector has sampled this session.
■    Oracle Process ID—Process ID of the Oracle server or shadow process.
■    Client Process ID—Process ID of the client or application process, if it is running on the same server as the instance; otherwise, it is zero.
■    Oracle Process Type—Type of Oracle server process: Dedicated or MTS.
See “In Oracle” on page 36.
Connection    Displays information for the following items:
■    Program—Name of the program connected to Oracle.
■    Module—Current Oracle module, if Oracle Modules and Actions are used.
■    User—Name of the Oracle user.
■    Host User—Name of the OS user connected to Oracle.
■    Machine—Name of the machine connected to Oracle.
■    Terminal—Name of the terminal connected to Oracle.
■    Sub-State—Snapshot of the In Oracle wait state.
■    Wait Event—Snapshot of the Oracle wait event. This is equivalent to the EVENT column in the
V$SESSION_WAIT table.
■    Open + Fetches—The number of times that the Collector encountered the session either opening or fetching from a cursor.
See “Executions vs. opens and fetches” on page 39.
In Oracle (Last Minute)    Displays information for the following items:
■    Sub-StateIn—Oracle sub-state.
■    Bar graph—Graphical representation of the Time column.
■    Time—Amount of time the session was in this state.
■    %—Percentage of time the session was in this state.

About the text of a current or active session
The Text view displays the SQL text for the statement that the session is currently executing, if any.

About associating a session with other entities
You can associate a Session, in the Main area of the Current tab, to different entities in the Association area. The information displayed is divided into different sets that show different aspects of the entity. Each set is accessed by a tab.


The following table describes the entities that are available in the Association area.

Table 4-4    Association area entities

Entity    Description
Statements    Displays a list of statements run by the session during the last minute.
Sessions Involved in Lock    Displays a list of other sessions locking or locked by this session during the last minute. Three of the tabs displayed here are the same as those displayed for a regular session. In addition, the Lock tab displays locking information that is equivalent to the information displayed in Oracle's V$SESSION_WAIT table (For more information, see the Oracle documentation).
Parallel Query Server Sessions    Displays Parallel Query Coordinator or Parallel Query Slave sessions associated with this session during the last minute. The tabs displayed here are the same as those displayed for a regular session.
See “About associating an Instance with other entities” on page 53.

Note: If you drill down to a Parallel Query Server process, the Main area displays information on this session. You can then identify the Parallel Query Coordinator Session using the Association controls.

The following table explains the information that is displayed on the tabs in the Association area, when the Statements entity is selected.

Table 4-5    Statements Association area table

Tab    Columns
Statement    Displays the following table columns:
■    Statement—Unique identifier assigned by the Collector to the SQL statement.
■    Hash Value—Value assigned to the statement by Oracle.
■    In Oracle—Bar graph showing the In Oracle breakdown.
■    Tune icon—Allows launching the SQL tab in the context of the current statement. Clicking elsewhere in the row drills down to the statement in Current tab.
■    Text—Portion of the SQL text for the statement. Note that if the cursor is moved over the text, then a tool-tip appears containing the full text of the statement.
See “Statement identifier vs. Oracle hash value” on page 39. See “In Oracle” on page 36.
In Oracle    Displays the following table columns:
■    Statement—Unique identifier assigned by the Collector to the SQL statement.
■    In Oracle—Bar chart showing the In Oracle breakdown for the session.
■    Using CPU—In Oracle wait state.
■    I/O wait—In Oracle wait state.
■    Application Lock wait—In Oracle wait state.
■    Commit & Checkpoint wait—In Oracle wait state.
■    Communication wait—In Oracle wait state.
■    Internal Lock wait—In Oracle wait state.
■    Oracle Server wait—In Oracle wait state.
■    Operating System wait—In Oracle wait state.
■    RAC/OPS/Other wait—In Oracle wait state.

See “Statement identifier vs. Oracle hash value” on page 39. See “In Oracle” on page 36.
Statistics    Displays the change in Oracle statistics for the statements in the last minute. See “Oracle statistics usage within Precise for Oracle” on page 40.


The following table explains the information that is displayed on the Lock tab in the Association area, when the
Sessions Involved in Lock entity is selected.

Table 4-6    Lock tab information

Column    Description
Program    Name of the program connected to Oracle.
Session ID    ID of the session.
In Oracle (Last Minute)    Bar chart showing the In Oracle breakdown for the session.
Status    Indicates whether the session is waiting for or holding the lock.
Type    Transaction type: TX, TM, and so on. This information is derived from the P1 parameter in the
V$SESSION_WAIT table.
Mode    Transaction mode: Exclusive, Shared, and so on. This information is derived from the P1 parameter in the V$SESSION_WAIT table.
ID1    This information is equivalent to P2 parameter in the V$SESSION_WAIT table.
ID2    This information is equivalent to P3 parameter in the V$SESSION_WAIT table.
Object    Locked object, if appropriate.
Text    Portion of SQL text for the session being locked.

About the Statement entity
The Statement entity, in the Current tab, displays information on a single SQL statement that has been run by a session in the last minute or is still running. You cannot associate a statement with any other entity. This implies that if the Main area displays information on a statement, the Association area remains blank.
See “About Precise for Oracle tabs” on page 21. Getting an overview of current Statement entities
The Statement Overview displays general information on a single SQL statement. The following table describes the information displayed in a Statement Overview.
Table 4-7    Statement Overview

View area    Description
Statement    Displays information on the following items:
■    Hash Value—Oracle hash value.
■    In Oracle (Sum.)—Total time spent In Oracle.
■    Opens + Fetches—Number of times sessions opened and fetched from a cursor for this statement.
In Oracle (Last Minute)    ■    Sub-State—In Oracle sub-state.
■    Bar graph—Graphical representation of the Time column.
■    Time—Amount of time sessions were in this state.
■    %—Percentage of time that sessions were in this state.
■    Sessions—Number of sessions in each state. Note a session may be in more than one state during a minute.
Overall Activity (Last
Minute)    A pie chart illustrating the overall activity of the statement during the last minute. See “Overall activity” on page 35.
Text    The SQL text of the statement.


About the text of a statement
The Text view displays the SQL text of the statement.


About statement-related statistics changes
The Statistics view displays a list of the changes that occurred in the Oracle statistics for the statement during the last minute.
See “Oracle statistics usage within Precise for Oracle” on page 40.
The following table describes the information displayed in the Statement Statistics view.

Table 4-8    Statement Statistics view

Column    Description
Statistic    Oracle statistic name
Value    Statistic value

...