Page History
...
- The top SQL tab provides more detailed information than provided on the Overview tab, in terms of executing SQL statements and procedures. For more information, see Top SQL Tab.
- The top ExecutionActivity (DB 2 Specific) tab provides details about the statements and procedures that ran. This is DB 2 specific. For more information, see Top Execution Activity Tab (DB2 Specific).The top Events tab displays information about wait events profiled by the execution process. For more information, see Top Events Tab.
- The top Sessions tab displays information about sessions profiled by the execution process. For more information, see Top Sessions Tab.
- The top Blockers tab (Oracle) displays information about blocking sessions. For more information, see Top Blockers Tab (Oracle Specific).
- The top ObjectI/O tab (Oracle-Specific) tab does not appear in the Top Activity Section unless the data source being profiled is an Oracle platform. This tab displays information about the I/O profiled by the execution process. For more information, see Top Object I/O Tab (Oracle-Specific).
- The top Procedures tab (Oracle and SQL Server-specific) displays information about procedures observed during profiling. For more information, see Top Procedures Tab (Oracle and SQL Server Specific).
...
Statistic | Shown for Platform | Notes |
---|---|---|
Exeutions | SQL Server, Oracle, DB2 | The number of active executions for the statement or statement component over the length of the profiling session or the selected graph bars. |
Avg. Elapsed (sec) | Oracle, DB2 | The average amount of time that elapsed while executing the statement during the profiling period. This column appears for only SQL Server, DB2 and Oracle data sources. |
DB Activity (%) | SQL Server, Oracle, DB2 | A graphical representation of the distribution of execution and wait time for the statement or statement component. |
SQL ID | Oracle | The ID value of the SQL statement. This statistic only appears on Oracle data sources. |
Child Number | Oracle | The child number in the database. This statistic only appears on Oracle data sources. |
Parsing User ID | Oracle | The ID of the user who parsed the statement. This statist only appears on Oracle data sources. |
Plan Hash Value | Oracle | The execution value of the statement. This statistic only appears on Oracle data sources. |
...
Anchor | ||||
---|---|---|---|---|
|
...