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 Tabtab.
  • The top Events tab displays information about wait events profiled by the execution process. For more information, see Top Events Tabtab.
  • The top Sessions tab displays information about sessions profiled by the execution process. For more information, see Top Sessions Tabtab
  • The top Blockers tab (Oracle) displays information about blocking sessions. For more information, see Top Blockers Tab (Oracle Specific)tab.
  • 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)tab.
  • 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)tab.

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 Sessions Tab provides information about individual sessions. This tab provides information about sessions that are very active or bottlenecked.

Anchor
_TOP_BLOCKERS_TAB
_TOP_BLOCKERS_TAB
Top Blockers tab

...

The Blockers tab provides details on sessions holding blocking locks.

...

Info

For more detailed information, see Viewing Details on the Blockers Tab (Oracle)

Anchor
_TOP_OBJECT_I/O
_TOP_OBJECT_I/O
Top Object I/O tab

...

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

...

ValueDescription
ObjectThe name of the data source object affecting the Oracle I/O.
TypeThe object type. For example, table, partition, or index.
DB Activity (%)Use the color chart on the right-hand side of the I/O tab to view the I/O load on the data source during the profiling session.
TablespaceThe name of the tablespace where the object resides.
File ID

The unique ID value of the file from where specified object resides. 


Anchor
_TOP_PROCEDURES_
_TOP_PROCEDURES_
Top Procedures tab

...

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

...