Versions Compared

Old Version 10

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version Current

changes.mady.by.user Nadja Pollard

Saved on

Key

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

...

The Current tab provides answers to the following types of questions: "How many sessions are currently running? ," or "Why doesn't my application work when I click OK?"

Using the Current tab, you can monitor current connections to your Oracle instance, check the state of each connection, and identify the resources currently utilized by each session. Further investigation of each session provides a thorough understanding of the SQL statement being executed, the login name executing the statement, the program, and the resource utilization for the session.

...

You can set the display to automatically refresh every few minutes; refresh can either be enabled or disabled from the Settings dialog box. If it is enabled, the display will be refreshed every <n> minutes, where <n> is the number specified in the Settings dialog box.

See “About About configuring general settings” on page 27, “How settings, How most tabs are structured” on page 22structured, and “About About the Dashboard tab” on page 43tab.

Anchor
HowtheCurrenttabisstructured
HowtheCurrenttabisstructured
How the Current tab is structured

...

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 About Precise for Oracle tabs” on page 21 and “About tabs and About the Dashboard tab” on page 43tab.

About examining entities in the Current tab

...

ItemDescription
Sessions

Displays information on the following items:

  • Connected. Number of sessions that were connected to the Oracle instance during the last minute.
  • Active. Number of sessions that were connected to the Oracle instance during the last minute and spent time executing In Oracle.
  • Locked. Number of locked sessions.
  • Sessions via Dedicated Server. Number of sessions that were connected to the Oracle instance using an Oracle dedicated server process (or shadow process) during the last minute.
  • Sessions via Shared Server. Number of sessions that were connected to the Oracle instance using an Oracle multi-threaded server process (MTS) during the last minute.
  • Active Sessions In Oracle. Average In Oracle time of active sessions during the last minute.
    Equals the total In Oracle time divided by the number of active sessions. The format is:
    hh:mm:ss.s
Parallelism

Displays information on the following items:

  • Idle Parallel Servers. Number of PQ servers that have not been used in the last minute.
  • Active Parallel Servers. Number of PQ servers that have been used in the last minute.
In Oracle (Last Minute)

Displays information on the following items:

  • Sub-State. In Oracle sub-state.
  • Bar graph. Graphical representation of the Time column.
  • Time. Amount of time that sessions were in this state.
  • %. Percentage of time that sessions were in this state.
  • Sessions. Number of sessions in each state. A session may be in more than one state during one minute.

See “In Oracle” on page 36 In Oracle.

Overall Activity (Last Minute)A pie chart illustrating the overall activity of all sessions during the last minute. See “Overall activity” on page 35 Overall activity.
Work Types (Last Minute)If the chosen instance has ERP support installed, this tab also displays a pie chart of work types.

Anchor
AboutAssocInstancewithOtherEntities
AboutAssocInstancewithOtherEntities
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:

...

TabColumns
General

Displays the following table columns:

  • Icon. Indicates the current sub-state.
  • Icon. Enables the Kill Session process.
  • Program. Name of the program connected to Oracle.
  • Session ID. Session ID or number.
  • Oracle Process ID. OS-assigned process ID of the Oracle server process.
  • Serial #. Oracle serial number, which, along with the session ID, uniquely identifies a session.
  • In Oracle. Bar chart showing the In Oracle breakdown for the session.
  • Sub-State. Snapshot of the current In Oracle wait sub-state.
  • Wait Event. Snapshot of the current Oracle wait event.
  • Tune icon. Allows launching the SQL tab in the context of the current statement.
  • Text. Portion of any SQL statement that is actually being executed at the time of the refresh; otherwise, it is blank.

See “In Oracle” on page 36 In Oracle.

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 In Oracle.

ConectionConnection

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  See About the Dashboard tab” on page 43tab.
  • 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 In Oracle.

Info

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 About the Session entity” on page 56entity.

About the Kill Session process

...

  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.

Anchor
AbouttheSessionentity
AbouttheSessionentity
About the Session entity

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

...

View areaDescription
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 In Oracle.

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 Executions vs. opens and fetches” on page 39fetches.

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.

...

EntityDescription
StatementsDisplays a list of statements run by the session during the last minute.
Sessions Involved in LockDisplays 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 About associating an Instance with other entities” on page 53entities.

Info

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.

...

TabColumns
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 Statement identifier vs. Oracle hash value” on page 39. See “In Oracle” on page 36value and In Oracle.

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 Statement identifier vs. Oracle hash value” on page 39. See “In Oracle” on page 36.value and In Oracle.

StatisticsDisplays the change in Oracle statistics for the statements in the last minute. See “Oracle Oracle statistics usage within Precise for Oracle” on page 40Oracle.

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.

...

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 About Precise for Oracle tabs” on page 21tabs.

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.

...

View areaDescription
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 Overall activity.
TextThe SQL text of the statement.

...

The Statistics view displays a list of the changes that occurred in the Oracle statistics for the statement during the last minute. See “Oracle Oracle statistics usage within Precise for Oracle” on page 40Oracle.

The following table describes the information displayed in the Statement Statistics view.

...