...
| Tab | Columns |
|---|
| 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. |
| 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. |
| 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 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. |
...
| 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 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 identifier vs. Oracle hash value and In Oracle. |
| Statistics | Displays 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.
...
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.
...