Session Details View (Oracle Performance Analyst)
Go Up to Oracle Performance Analyst Statistics
The following tabbed pages are available on the Session Details page:
Contents
Overview Tab
Several sections are available on the Overview tab of the Session Details page. The table below describes the sections:
Section | Description |
---|---|
Memory Usage |
The Memory Usage section defines the session's total memory usage against all session memory usage on the database. |
I/O Activity |
The I/O section defines the session's total I/O consumption against all I/O activity on the database. NOTE Bugs in some versions of the Oracle data dictionary cause negative numbers to display if the database has experienced large amounts of I/O activity. |
CPU Activity |
The CPU Activity section defines the session's total CPU consumption against all CPU usage on the database. NOTE Bugs in some versions of the Oracle data dictionary cause the total CPU usage for a session to not be calculated correctly. |
Statistical Detail |
The Statistical Detail section details every performance metric available for the session. NOTE Each measure continue to increment as long as the session stays connected to Oracle. |
Current Work Tab
The Current Work tab of the Session Details page includes the following sections:
The following statistic, available on this tab, duplicates a statistic available on the Key User Analysis Pane
Open Transactions
This Open Transactions section displays details regarding any open transaction that the session currently has. The table below describes the information available in this section:
Column | Description |
---|---|
SQL Text |
The SQL that contains the transaction. |
Start Time |
The time the statement was issued. |
Logical I/O |
The amount of memory I/O the transaction has used. |
Physical I/O |
The amount of disk I/O the transaction has used. |
Gets |
A subset of logical I/O. |
Changes |
Any data modifications made by the transaction. |
Location |
Oracle Performance Analyst Statistics > Session Details View (Oracle Performance Analyst) > Current Work Tab |
Metrics
Seeing a long running, persistent transaction might indicate a session caught in a loop or other coding snafu. Watching a transaction sit idle could clue you into a lock contention problem that exists.
Waits Tab
The Waits tab of the Session Details page includes the following sections:
The following statistics, available on this tab, are duplicates of statistics available on the System Waits Tab of the Users View (Oracle Performance Analyst) page:
Time Summary (Oracle 10g only)
The Time Summary section shows you where the session has been spending its time. Using the Time Summary section, you can easily determine if a session has been bottlenecked by SQL calls, PL/SQL work, or other activities.
Location |
Oracle Performance Analyst Statistics > Session Details View (Oracle Performance Analyst) > Waits Tab |
Last Ten Waits (Oracle 10g only)
The Last Ten Waits section shows you, in order, the last 10 wait events experienced by the session, along with other important metrics like the wait time, and so forth.
Location |
Oracle Performance Analyst Statistics > Session Details View (Oracle Performance Analyst) > Waits Tab |
Locks Tab
The following statistics, available on this tab, are duplicates of statistics availale on the Locks/Blocking Locks Tab of the Users View (Oracle Performance Analyst) page:
SQL Tab
The SQL tab of the Session Details page includes the following sections:
Current SQL
The Current SQL section displays the most current SQL issued by the session.
- Note: You can run an EXPLAIN PLAN on the SQL or (if you have IDERA SQL Tuner installed) tune the SQL for better performance.
Location |
Oracle Performance Analyst Statistics > Session Details View (Oracle Performance Analyst) > SQL Tab |
Current SQL Statistics
The Current SQL Statistics section displays the performance execution metrics for the current SQL statement in graphical format. Physical and logical I/O is displayed along with rows processed and number of executions.
Location |
Oracle Performance Analyst Statistics > Session Details View (Oracle Performance Analyst) > SQL Tab |
Other SQL
The Other SQL section displays other SQL that has been parsed by the Oracle username. The table below describes the information available in this section:
Column | Description |
---|---|
SQL Text |
A snippet of the SQL code issued. |
Disk Reads |
The number of total disk reads for the statement. |
Buffer Gets |
The number of total buffer gets for the statement. |
Rows Processed |
The number of total rows processed for the statement. |
Executions |
The number of times the statement has been executed. |
Sorts |
The number of sorts for the statement. |
- Note: Bugs in some versions of Oracle will cause negative numbers to display for various execution metrics.