Page History

Versions Compared

Key

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

...

Tab Name	Description	Supported Platform
Tab Name	Description	Oracle	Sybase	DB2	SQL Server
SQL Text	Displays the full code of the selected SQL statement.	Yes	Yes	Yes	Yes
SQL Details	Provides details on statement, like execution statistics.	Yes	No	Yes	No
Events	Provides database activity details about events the statement is associated with.	Yes	Yes	Yes	Yes
Sessions	Shows which sessions executed this statement.	Yes	Yes	Yes	Yes
Blockers	Shows which sessions held blocking locks against the session associated with this statement. Double-clicking an entry on this tab opens that session in the Top Blockers tab, letting you find more information on the blocking session. For details, see Top Blockers Tab (Oracle Specific).	Yes	No	No	No
Children Details	Lists all copies of the cursor or SQL query, if Oracle has cached multiple copies of the same statement.	Yes	No	No	No
Object I/O	If the SQL query has done physical I/O, then these are the objects, such as tables, and indexes that were read to satisfy the query. Temporary objects with not have values in Object and Type columns.	Yes	No	No	No
Procedures	Shows which procedures contain the selected statement.	No	Yes	No	Yes
Bind Variable Details	Shows bind variable information for SQL captured during the Profiling session.	Yes	No	No	No

...

Tab Name	Description	Supported Platform
Tab Name	Description	Oracle	Sybase	DB2	SQL Server
SQL	Shows which SQL statements waited on this event.	Yes	Yes	Yes	Yes
Sessions	Provides information about the sessions associated with the event.	Yes	Yes	Yes	Yes
Blockers	Shows which sessions held blocking locks against the session associated with this event. Double-clicking an entry on this tab opens that session in the Top Blockers tab, letting you find more information on the blocking session. For details, see Top Blockers Tab (Oracle Specific).	Yes	No	No	No	Yes	No	No	No
Procedures	Shows which procedures contain the selected event.	No	Procedures	Shows which procedures contain the selected event.	No	Yes	No	Yes
Raw Data	Raw data that was sampled from the database, specifically the following: Sample time SID Serial # User name Program Sql ID P1 P2 P3	Yes	No	No	No
Analysis	Displays for "buffer busy waits" and "cache buffer chains latch" waits. The analysis shows data and documentation to assist in solving these bottlenecks.	Yes	No	No	No

...

Tab Name	Description	Supported Platforms
Tab Name	Description	Oracle	Sybase	DB2	SQL Server
Sessions	Provides parameters regarding the session. For example, database server connection information, and data regarding the client tool and application.	Yes	Yes	No	Yes
Blockers	Shows which sessions held blocking locks while this session was active. Double-clicking an entry on this tab opens that session in the Top Blockers tab, letting you find more information on the blocking session. For details, see Top Blockers Tab (Oracle Specific).	Yes	No	No	No		Yes	No	No	No
SQL	Shows which SQL statements this session ran.	Yes	SQL	Shows which SQL statements this session ran.	Yes	Yes	Yes	Yes
Events	Shows which events this session waited on.	Yes	Yes	Yes	Yes
Procedures	Shows which procedures ran the selected session.	No	Yes	No	Yes

...

Value	Notes
User Name	The user name under which the session was run.
Program	The name of the executable under which the session was run.
SID	The SID value of the session.
Serial Number	The serial number of the machine from which the session executed.
Activity (%)	A graphical representation of the distribution of execution and wait time for the statement or statement component.
Machine	The machine name and network location of the machine from which the session executed.
Session Type	The type of session.

For the Oracle Platform, you can kill a session by right-clicking the entry on the Sessions tab and choosing Kill Session. You can start a trace on a session by right-clicking the entry on the Sessions tab and choosing Trace. For more information, see Killing an Oracle session and Tracing an Oracle session.

Legal

Scroll Ignore