Page History
...
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.
Info |
---|
If you are working with Oracle Applications, SAP, PeopleSoft, or Siebel and ERP support is installed, the Current tab displays information on the current Oracle activity in relation to the ERP application and users, and specific information on executed views and transactions. |
See “Precise Interpoint - how resource consumption of packaged applications is examined” on page 40.
In the Current tab, data on a current session is continuously updated to provide information on what happened during the last minute. Because the displayed session information is derived from a dynamic application, it is recommended to regularly refresh the screen, either manually or automatically, to ensure that the information displayed is up-to-date.
...
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 | ||||
---|---|---|---|---|
|
...
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
...
Item | Description |
---|---|
Sessions | Displays information on the following items:
|
Parallelism | Displays information on the following items:
|
In Oracle (Last Minute) | Displays information on the following items:
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 | ||||
---|---|---|---|---|
|
You can associate an Instance, in the Main area of the Current tab, with the following entities in the Association area:
...
Tab | Columns |
---|---|
General | Displays the following table columns:
See “In Oracle” on page 36 In Oracle. |
In Oracle | Displays the following table columns:
See “In Oracle” on page 36 In Oracle. |
ConectionConnection | Displays the following table columns:
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
...
- On the general tab of the Instance Association, select the session that needs to be killed.
- Click Kill Session.
- In the dialog, insert the Oracle DBA user name and password.
- Mark Kill immediately.
- Click OK.
Anchor | ||||
---|---|---|---|---|
|
The Session entity displays information on a single connection with Oracle.
...
View area | Description |
---|---|
Session | Displays information for the following items:
See “In Oracle” on page 36 In Oracle. |
Connection | Displays information for the following items:
See “Executions Executions vs. opens and fetches” on page 39fetches. |
In Oracle (Last Minute) | Displays information for the following items:
|
...
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 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. |
...
Tab | Columns |
---|---|
Statement | Displays the following table columns:
See “Statement Statement identifier vs. Oracle hash value” on page 39. See “In Oracle” on page 36.value and In Oracle. |
In Oracle | Displays the following table columns:
See “Statement Statement identifier vs. Oracle hash value” on page 39. See “In Oracle” on page 36.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.
...
View area | Description |
---|---|
Statement | Displays information on the following items:
|
In Oracle (Last 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. |
Text | The 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.
...
For our example, in the Main area, you can see that the holding session (for Duration) has not run any statements in the last 15-minute time slice, meaning that the UPDATE to the CUSTOMER table (for Program) was executed earlier but that the session has not yet issued a COMMIT to release the row lock.