Page History

...

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 Modified

• 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 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 displays information about blocking sessions. For more information, see Top Blockers tab.
• The top ObjectI/O tab displays information about the I/O profiled by the execution process. For more information, see Top Object I/O tab.
• The top Procedures tab displays information about procedures observed during profiling. For more information, see Top Procedures tab.

...

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 Modified

Anchor
_TOP_SESSIONS_TAB _TOP_SESSIONS_TAB

Top Sessions tab

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

Image Modified

Anchor
_TOP_BLOCKERS_TAB _TOP_BLOCKERS_TAB

Top Blockers tab

The Blockers tab provides details on sessions holding blocking locks.

Image Modified

The following parameters are displayed on the Blockers tab:

...

The Object I/O tab displays information about Oracle I/O loads on the profiled data source.

Image Modified

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

...

The Procedures tab displays information about Procedure loads on the profiled data source.

Image Modified

The following parameters are displayed on the Procedures tab:

...