Page History
...
The following parameters are displayed on the Procedures tab:
| 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. |
| Anchor | ||||
|---|---|---|---|---|
|
...
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.
| Tab |
|---|
...
| Name | Description | Supported Platform | |||
|---|---|---|---|---|---|
| Oracle | Sybase | DB2 | SQL Server | ||
| SQL | |||||
...
| Text | Displays the full code of the selected SQL statement. |
...
| Yes | Yes | Yes | Yes | |
| SQL Details | Provides details on statement, like execution statistics. |
...
| Yes | No | Yes | No | |
| Events | Provides database activity details about events the statement is associated with. |
...
| Yes | Yes | Yes | Yes | |
| Sessions | Shows |
...
| which sessions executed this statement. |
...
| Yes | Yes | Yes | Yes | |
| Blockers | 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, |
...
...
| Yes | No | No | No |
...
| Children |
...
| Details | Lists all copies of the cursor or SQL query, if Oracle has cached multiple copies of the same statement. |
...
| Yes | No | No | No | |
| Object I/ |
...
| O | If the SQL query has done physical I/O, then these are the objects, such as tables, and indexes that were read to satisfy the query. Temporary objects with not have values in Object and Type columns. |
...
| Yes | No | No | No |
| Procedures | Shows which procedures contain the selected statement. |
...
| No | Yes | No | Yes | |
| Bind Variable Details | Shows bind variable information for SQL captured during the Profiling session. |
...
| Yes | No | No | No |
Event
...
Selected
When an Event is selected, the following Profile Detail tabs are available.
| Tab |
|---|
...
| Name | Description | Supported Platform | |||
|---|---|---|---|---|---|
| Oracle | Sybase | DB2 | SQL Server | ||
| SQL | Shows which SQL statements waited on this event. | ||||
...
| Yes | Yes | Yes | Yes | |
| Sessions | Provides information about the sessions associated with the event. |
...
| Yes | Yes | Yes | Yes | |
| Blockers | 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, |
...
...
| Yes | No | No | No | |
| Procedures | Shows which procedures contain the selected event. |
...
| No | Yes | No | Yes | |
| Raw Data | Raw data that was sampled from the database, specifically the following: |
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
| Yes | No | No | No |
| Analysis | Displays for "buffer busy waits" and "cache buffer chains latch" waits. The analysis shows data and documentation to assist in solving these bottlenecks. | Yes |
...
| No | No |
...
| No |
Session Selected
When a Session is selected, the following Profile Detail tabs are available.
| Tab |
|---|
...
| Name | Description | Supported Platforms | |||
|---|---|---|---|---|---|
| Oracle | |||||
...
| Sybase | DB2 | SQL Server | |
|---|---|---|---|
| Sessions |
...
Provides parameters regarding the session. For example, database server connection information, and data regarding the client tool and application. |
...
| Yes | Yes | No | Yes | ||
| Blockers | 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 . | ||||
| SQL | |||||
| Events | |||||
| Procedures |
Provides
| Wiki Markup |
|---|
yesyesyes
\\
\\
BlockersShows 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 details, see [Top Blockers Tab (Oracle Specific)|WORK WITH SESSION RESULTS#_TOP_BLOCKERS_TAB].
yes
\\
SQLShows which SQL statements this session ran.yesyesyesyes
\\
\\
EventsShows which events this session waited on.yesyesyesyes
\\
\\
Procedures Shows which procedures ran the selected session.yesyes
\\
\\
<span style="color: #444087">NOTE:</span> When right-clicking on a SQL statement in the Top Activity Section in Profiling, if the SQL statement is run by a different user than the user who is running DBO, than the User Mismatch dialog appears, with an example of the following message: "This query was executed by \[SOE\] and you are currently connected as \[system\]. We recommend you reconnect as \[SOE\] to tune the SQL. Would you like to continue anyway?" This message indicates that the statement is being tuned by a user other than the user who originally ran the query, and tables may be missing based on the different schemas. Click OK to run the query, or click Cancel and run tuning under the original user.
\\
\\
*Blocking* *Session* *Selected*
When a *Blocking* *Session* is selected, the following Profiling Detail tabs are available.
\\
Tab NameDescriptionSupported Platform
\\
Oracle SybaseDB2 SQL Server
\\
Blocked
Sessions
\\
Session
Details |
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.
...