Page History
...
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, see Top Blockers Tab (Oracle Specific). | 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 |
...
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, see Top Blockers Tab (Oracle Specific). | Yes | No | No | No | Yes | No | No | No | |
Procedures | Shows which procedures contain the selected | 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 |
...
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 details, see Top Blockers Tab (Oracle Specific). | Yes | No | No | No | Yes | No | No | No | |
SQL | Shows which SQL statements this session ran. | Yes | 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 "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. |
...
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 |
...
Tab Name | Description | Supported Platform | |||
---|---|---|---|---|---|
Oracle | Sybase | DB2 | SQL Server | ||
SQL Text | Shows the SQL text of the selected procedure. | No | Yes | No | Yes |
SQL | Shows which SQL statements this procedure ran. | No | Yes | No | Yes |
Events | Shows which events the selected procedure waited on. | No | Yes | No | Yes |
Sessions | Provides parameters regarding the session. For example, database server connection information, and data regarding the client tool and application. | No | Yes | No | Yes |
This section also addresses the following topics:
...
Parameters | Description |
---|---|
SQL Identification Values | The SQL ID value of the statement. |
Optimizer and Outline Values | Optimizer-specific values pertaining to the parsing user ID value and outline SID. |
Parsing Statistics | Information regarding memory, loads, and invalidation values. |
Execution Statistics | The execution statistics of the statement. This category includes disk reads, buffer gets, rows, and values that represent CPU and elapsed time. |
...
Value | Notes |
---|---|
Statement | The name of the statement. |
SQL ID | The ID value of the SQL statement. |
Child Number | The child number in the database. |
Parsing User ID | The ID of the user who parsed the statement. |
Plan Hash Value | The execution value of the statement. |
CPU | Cumulative CPU time for the process. (measured in "ticks", an arbitrary unit of time) |
Physical IO | Cumulative disk reads and writes for the process. (total count) |
Memory Usage | Number of pages in the procedure cache that are currently allocated to this process. A negative number indicates that the process is freeing memory allocated by another process. |
Executions | The number of times the statement was executed. |
Activity (%) | A graphical representation of the distribution of execution and wait time for the statement or statement component. |
...
Value | Notes |
---|---|
User Name | The user name under which the session was run. |
Program | The name of the executable under which the session was run. |
SID | The SID value of the session. |
Serial Number | The serial number of the machine from which the session executed. |
Activity (%) | A graphical representation of the distribution of execution and wait time for the statement or statement component. |
Machine | The machine name and network location of the machine from which the session executed. |
Session Type | The type of session. |
For the Oracle Platform, you can kill a session by right-clicking the entry on the Sessions tab and choosing Kill Session. You can start a trace on a session by right-clicking the entry on the Sessions tab and choosing Trace. For more information, see Killing an Oracle session and Tracing an Oracle session.
Scroll Ignore | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
| |||||||||||||||||||||||||||||||||||||||||
Newtabfooter | ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Scroll pdf ignore | ||||||||||||||||||||||||||||||||||||||||||||||||
Automate SQL tuning and profiling with DB Optimizer. Learn more > > | IDERA Website | Products | Purchase | Support | Community | About Us | Resources | Legal