Page History
...
The Top Events tab displays information about wait events on the resources involved in the profiling process. This display is used to tune at the application or database configuration level. For example, if the top events are locks, then application logic needs to be examined. If top events are related to database configuration, then database setup should be investigated.
| Info |
|---|
The columns that display are data source-dependent. For example, the Wait Count and Avg. Per Wait (sec) columns display only for an Oracle data source. |
...
The Sessions Tab provides information about individual sessions. This tab provides information about sessions that are very active or bottlenecked.
| Anchor | ||||
|---|---|---|---|---|
|
The Blockers tab provides details on sessions holding blocking locks.
The following parameters are displayed on the Blockers tab:
...
The Object I/O Tab is specific to the Oracle data source platform, and displays information about Oracle I/O loads on the profiled data source.
The following parameters are displayed on the I/O tab:
...
The Procedures tab is specific to Oracle, SQL Server, and Sybase data source platforms. It displays information about Procedure loads on the profiled data source.
The following parameters are displayed on the Procedures tab:
...
In the Top Activities Section, selecting an entry on the Blocked Sessions tab displays information on sessions holding blocking locks in the Profiling Details view.
Blocked Sessions
The Blocked Sessions tab provides general information on blocked sessions and the details identifying the specific row locked.
This tab provides the following columns for each blocked session:
Value | Notes |
User Name | The user name under which the blocking session was run. |
SID | The SID value of the blocking session. |
ROW_WAIT_OBJ# | Object ID of the table containing the row specified in ROW_WAIT_ROW#. |
ROW_WAIT_FILE# | Identifier of the datafile containing the row specified in |
ROW_WAIT_BLOCK# | Identifier of the block containing the row specified in ROW_WAIT_ROW#. |
ROW_WAIT_ROW# | The current row being locked. |
...
| Value | Description |
|---|---|
| Procedure Name | The name of the procedure affecting the database performance. |
| Database Name (SQL Server, Sybase only) | The name of the database where the procedure resides. |
| Oracle (Oracle only) | The owner of the schema in which the procedure resides. |
| Procedure ID | A unique ID created when the procedure is created. |
| Executions (SQL Server, Sybase only) | The number of times the procedure was executed during the session. |
...
The Profiling Details view displays detailed information on any item selected in the Top Section View, such as an SQL statement, an Event, a Session or a Procedure.
Depending on the data source platform you have specified, the tabs that appear in the view will be different, in order to accommodate the parameter specifics of the statement you have selected.
Depending on the top activity selected and the profiled platform types, some tabs may not be available.
Statement Selected
When a Statement is selected, the following Profile Detail tabs are available.
...
Shows which sessions held blocking locks against the session associated with this statement.
Double-clicking an entry on this tab opens that session in the Top Blockers tab, letting you find more information on the blocking session. For details, see Top Blockers Tab (Oracle Specific).
...
Lists all copies of the cursor or SQL query, if Oracle has cached multiple copies of the same statement.
...
Shows bind variable information for SQL captured during the Profiling session.
...
Event Selected
When an Event is selected, the following Profile Detail tabs are available.
...
Shows which sessions held blocking locks against the session associated with this event.
Double-clicking an entry on this tab opens that session in the Top Blockers tab, letting you find more information on the blocking session. For details, see Top Blockers Tab (Oracle Specific).
...
Shows which procedures contain the selected event.
...
Raw data that was sampled from the database, specifically the following:
- Sample time
- SID
- Serial #
- User name
- Program
- Sql ID
- P1
- P2
- P3
...
Displays for "buffer busy waits" and "cache buffer chains latch" waits. The analysis shows data and documentation to assist in solving these bottlenecks.
...
Session Selected
When a Session is selected, the following Profile Detail tabs are available.
...
Provides parameters regarding the session. For example, database server connection information, and data regarding the client tool and application.
...
Shows which sessions held blocking locks while this session was active.
double-clicking an entry on this tab opens that session in the Top Blockers tab, letting you find more information on the blocking session. For more details, see .
...
Provides identifier and V$SESSION session information on the sessions being locked by the blocking session.
Provides parameters regarding the session. For example, database server connection information, and data regarding the client tool and application.
...
yesyes
This section also addresses the following topics:
• Viewing Details on the SQL Tab
• Viewing Details on the Sessions Tab
• Viewing Details on the Events Tab
• Viewing Details on the Procedures Tab
...
The SQL Details tab provides information and the execution of the statement and other information related to how it is running. It is only applicable to Oracle data sources:
...
The Events tab provides details about the events that the statement is associated with.
...
The Sessions tab provides information about any sessions the statement is associated with:
Session details include information on different parameters, depending on the platform. For example, on Oracle platforms, the following parameters are displayed: User Name, Program, SID, Serial #, Activity (%), Network Machine Name, and Session Type.
...
The Procedures tab provides information about any procedures containing the selected statement.
The following parameters are displayed on the Procedures tab:
Value Description
Procedure NameThe name of the procedure that contains the selected statement. Database NameThe name of the database where the procedure resides.
Procedure IDThe unique ID value of the file where the specified procedure resides. ExecutionsThe number of times the procedure was executed.
DB Activity (%)Use the color chart on the right-hand side of the Procedures tab to view the procedures load on the data source during the profiling session.
...
| . |