Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Top Activity Section is composed of a series of tabs that provide detailed statistics on individual SQL statements and sessions that were waiting or executing over the length of a profiling session.

Image RemovedImage Added

  • 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, SQL Server, and Sybase-specific) displays information about procedures observed during profiling. For more information, see Top Procedures Tab (Oracle, SQL Server, and Sybase Specific).

...