Page History
...
When a Statement is selected, the following Profile Detail tabs are available.
| Tab Name | Description | Supported Platform | ||
|---|---|---|---|---|
| Oracle | DB2 | SQL Server | ||
| SQL Text | Displays the full code of the selected SQL statement. | Yes | Yes | Yes |
| SQL Details | Provides details on statement, like execution statistics. | Yes | Yes | No |
| Events | Provides database activity details about events the statement is associated with.Yes | Yes | Yes | |
| Sessions | Shows which sessions executed this statement. | 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, see Top Blockers Tab (Oracle Specific). | YesNo | No | |
| Children Details | Lists all copies of the cursor or SQL query, if Oracle has cached multiple copies of the same statement. | YesNo | 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. | YesNo | No | |
| Procedures | Shows which procedures contain the selected statement. | No | No | Yes |
| Bind Variable Details | Shows bind variable information for SQL captured during the Profiling session. | YesNo | No | |
Event selected
When an Event is selected, the following Profile Detail tabs are available.
| Tab Name | Description | Supported Platform | |
|---|---|---|---|
| OracleDB2 | SQL Server | ||
| SQL | Shows which SQL statements waited on this event.Yes | Yes | Yes |
| Sessions | Provides information about the sessions associated with the event. 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, see Top Blockers Tab (Oracle Specific). | YesNo | No |
| Procedures | Shows which procedures contain the selected event. No | No | Yes |
| Raw Data | Raw data that was sampled from the database, specifically the following:
| YesNo | 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. | YesNo | No |
Session selected
When a Session is selected, the following Profile Detail tabs are available.
| Tab Name | Description | Supported Platforms | ||
|---|---|---|---|---|
| Oracle | DB2 | SQL Server | ||
| Sessions | Provides parameters regarding the session. For example, database server connection information, and data regarding the client tool and application. | 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 details, see Top Blockers Tab (Oracle Specific). | Yes | No | No |
| SQL | Shows which SQL statements this session ran.Yes | Yes | Yes | |
| Events | Shows which events this session waited on. | Yes | Yes | Yes |
| Procedures | Shows which procedures ran the selected session.No | No | Yes | |
| Info |
|---|
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. |
...
When a Blocking Session is selected, the following Profiling Detail tabs are available.
| Tab Name | Description | Supported Platform | ||
|---|---|---|---|---|
| OracleDB2 | SQL Server | |||
| Blocked Sessions | Provides identifier and V$SESSION session information on the sessions being locked by the blocking session. | YesNo | No | |
| Session Details | Provides parameters regarding the session. For example, database server connection information, and data regarding the client tool and application. | Yes | No | No |
| SQL | Shows the SQL statements associated with the lock. | YesNo | No | |
| Events | Shows which events the blocking session waited on. | YesNo | No | |
Procedure selected
When a Procedure is selected, the following Profile Detail tabs are available.
| Tab Name | Description | Supported Platform | |
|---|---|---|---|
| OracleDB2 | SQL Server | ||
| SQL Text | Shows the SQL text of the selected procedure.No | No | Yes |
| SQL | Shows which SQL statements this procedure ran.No | No | Yes |
| Events | Shows which events the selected procedure waited on.No | No | Yes |
| Sessions | Provides parameters regarding the session. For example, database server connection information, and data regarding the client tool and application.No | No | Yes |
This section also addresses the following topics:
...