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.
- 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 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 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 tab displays information about procedures observed during profiling. For more information, see Top Procedures Tab (Oracle, SQL Server, and Sybase 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.
...
Info |
---|
Columns displayed on the top SQL tab differ depending on the data source platform. |
StatisticShown for Platform | Notes | |
---|---|---|
ExeutionsSQL Server, Oracle, DB2 | The number of active executions for the statement or statement component over the length of the profiling session or the selected graph bars. | |
Avg. Elapsed (sec)Oracle, DB2 | The average amount of time that elapsed while executing the statement during the profiling period. This column appears for only SQL Server, DB2 and Oracle data sources. | |
DB Activity (%)SQL Server, Oracle, DB2 | A graphical representation of the distribution of execution and wait time for the statement or statement component. | |
SQL IDOracle | The ID value of the SQL statement. This statistic only appears on Oracle data sources. | |
Child Number | Oracle | The child number in the database. This statistic only appears on Oracle data sources. |
Parsing User IDOracle | The ID of the user who parsed the statement. This statist only appears on Oracle data sources. | |
Plan Hash Value | Oracle | The execution value of the statement. This statistic only appears on Oracle data sources. |
...
. |
Anchor | ||||
---|---|---|---|---|
|
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.
...
Anchor | ||||
---|---|---|---|---|
|
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.
The following parameters are displayed on the Blockers tab:
...
Info |
---|
For more detailed information, see Viewing Details details on the Blockers Tab (Oracle)tab. |
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.
The following parameters are displayed on the I/O tab:
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, SQL Server, and Sybase data source platforms. It displays information about Procedure loads on the profiled data source.
The following parameters are displayed on the Procedures tab:
Value | Description | ||
---|---|---|---|
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. |
...
| ||||||||
Newtabfooter | ||||||||
---|---|---|---|---|---|---|---|---|
|
...