Page History
...
- 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 | ||||
---|---|---|---|---|
|
...
The Blockers tab provides details on sessions holding blocking locks.
...
Info |
---|
For more detailed information, see Viewing Details on the Blockers Tab (Oracle). |
Anchor | ||||
---|---|---|---|---|
|
...
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.
...
Value | Description |
---|---|
Object | The name of the data source object affecting the Oracle I/O. |
Type | The 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. |
Tablespace | The name of the tablespace where the object resides. |
File ID | The unique ID value of the file from where specified object resides. |
Anchor | ||||
---|---|---|---|---|
|
...
The Procedures tab is specific to Oracle and SQL Server data source platforms. It displays information about Procedure loads on the profiled data source.
...