Versions Compared

Key

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

...

  • 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 , and Sybase Specific).

When you select any item from the Top Activity tabs, details are displayed in the Profiling Details view. The tabs that appear in Profiling Details will be different depending on the database platform and whether you selected a statement, session, or an event. This is to accommodate the parameter specifics of the item you selected.

...

The Procedures tab is specific to Oracle , and SQL Server , and Sybase data source platforms. It displays information about Procedure loads on the profiled data source.

...

ValueDescription
Procedure Name

The name of the procedure affecting the database performance.

Database Name (SQL Server , Sybase only)

The name of the database where the procedure resides.

Oracle (Oracle only)

The owner of the schema in which the procedure resides.

Procedure ID

A unique ID created when the procedure is created.

Executions (SQL Server , Sybase only)The number of times the procedure was executed during the session.