Versions Compared

Key

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

...

Info

The image below depicts results achieved for a Sybase database. The columns displayed on this tab differ depending on the database platform. 

Image AddedImage Removed

Statements

Statements can be grouped by type by right-clicking the view and selecting Organize > By Type.

...

The Top Events tab displays information about wait events on the resources involved in the profiling process. This display is used to tune at the application or database configuration level. For example, if the top events are locks, then application logic needs to be examined. If top events are related to database configuration, then database setup should be investigated.

Image RemovedImage Added

Info

The columns that display are data source-dependent. For example, the Wait Count and Avg. Per Wait (sec) columns display only for an Oracle data source.

...

The Sessions Tab provides information about individual sessions. This tab provides information about sessions that are very active or bottlenecked.

Image RemovedImage Added

Anchor
_TOP_BLOCKERS_TAB
_TOP_BLOCKERS_TAB
Top Blockers Tab (Oracle Specific)

The Blockers tab provides details on sessions holding blocking locks.

Image RemovedImage Added

The following parameters are displayed on the Blockers tab:

...

The Object I/O Tab is specific to the Oracle data source platform, and displays information about Oracle I/O loads on the profiled data source.

Image RemovedImage Added

The following parameters are displayed on the I/O tab:

...

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

Image RemovedImage Added

The following parameters are displayed on the Procedures tab:

...