Page History
...
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. doubleDouble-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 | ProceduresFor more details, see Top Blockers Tab (Oracle Specific). | Yes | No | No | No |
SQL | Shows which SQL statements this session ran. | Yes | Yes | Yes | Yes | |||
Events | Shows which events this session waited on. | Yes | Yes | Yes | Yes | |||
Procedures | Shows which procedures ran the selected session. | No | Yes | 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. |
Blocking Session Selected
When a Blocking Session is selected, the following Profiling Detail tabs are available.
Tab Name | Description | Supported Platform | |||
---|---|---|---|---|---|
Oracle | Sybase | DB2 | SQL Server | ||
Blocked Sessions | Provides identifier and V$SESSION session information on the sessions being locked by the blocking session. | Yes | No | No | 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 | No | |
SQL | Shows the SQL statements associated with the |
...
lock. | Yes | No | No | No |
Events | Shows which events the blocking session waited on. |
...
Yes | No | No | No |
Procedure Selected
When a Procedure is selected, the following Profile Detail tabs are available.
Tab NameDescriptionSupported Platform
Oracle SybaseDB2 SQL Server
SQL TextShows the SQL text of the selected procedure.yesyes
SQLShows which SQL statements this procedure ran.yesyes
EventsShows which events the selected procedure waited on.yesyes
SessionsProvides parameters regarding the session. For example, database server connection information, and data regarding the client tool and application.
...