Versions Compared

Key

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

...

Tab NameDescriptionSupported Platform
OracleSybaseDB2SQL Server
SQL TextDisplays the full code of the selected SQL statement.YesYesYesYes
SQL DetailsProvides details on statement, like execution statistics.YesNoYesNo
EventsProvides database activity details about events the statement is associated with.YesYesYesYes
SessionsShows which sessions executed this statement.YesYesYesYes
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).

YesNoNoNo
Children Details

Lists all copies of the cursor or SQL query, if Oracle has cached multiple copies of the same statement.

YesNoNoNo
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.

YesNoNoNo
ProceduresShows which procedures contain the selected statement.NoYesNoYes
Bind Variable Details

Shows bind variable information for SQL captured during the Profiling session.

YesNoNoNo

...

Tab NameDescriptionSupported Platform
OracleSybaseDB2SQL Server
SQLShows which SQL statements waited on this event.YesYesYesYes
SessionsProvides information about the sessions associated with the event. YesYesYesYes
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).

YesNoNoNo

YesNoNoNo
Procedures

Shows which procedures contain the selected

Procedures

Shows which procedures contain the selected event.

NoYesNoYes
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 
YesNoNoNo
Analysis

Displays for "buffer busy waits" and "cache buffer chains latch" waits.

The analysis shows data and documentation to assist in solving these bottlenecks.

YesNoNoNo

...

Tab NameDescriptionSupported Platforms
OracleSybaseDB2SQL Server
Sessions

Provides parameters regarding the session.

For example, database server connection information, and data regarding the client tool and application.

YesYesNoYes
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).

YesNoNoNo

YesNoNoNo
SQLShows which SQL statements this session ran.YesSQLShows which SQL statements this session ran.YesYesYesYes
EventsShows which events this session waited on.YesYesYesYes
ProceduresShows which procedures ran the selected session.NoYesNoYes
Info

When right-clicking on a SQL statement in the Top Activity Section in Profiling, if the SQL statement is run by a different user than the user who is running DBO, than the User Mismatch dialog appears, with an example of the following message: “This "This query was executed by [SOE] and you are currently connected as [system]. We recommend you reconnect as [SOE] to tune the SQL. Would you like to continue anyway?" This message indicates that the statement is being tuned by a user other than the user who originally ran the query, and tables may be missing based on the different schemas. Click OK to run the query, or click Cancel and run tuning under the original user.

...

Tab NameDescriptionSupported Platform
OracleSybaseDB2SQL Server
Blocked Sessions

Provides identifier and V$SESSION session information on the sessions being locked by the blocking session. 

YesNoNoNo
Session Details

Provides parameters regarding the session.

For example, database server connection information, and data regarding the client tool and application.

YesNoNoNo
SQL

Shows the SQL statements associated with the lock.

YesNoNoNo
Events

Shows which events the blocking session waited on.

YesNoNoNo

...

Tab NameDescriptionSupported Platform
OracleSybaseDB2SQL Server
SQL TextShows the SQL text of the selected procedure.NoYesNoYes
SQLShows which SQL statements this procedure ran.NoYesNoYes
EventsShows which events the selected procedure waited on.NoYesNoYes
Sessions

Provides parameters regarding the session.

For example, database server connection information, and data regarding the client tool and application.

NoYesNoYes

This section also addresses the following topics: 

...

ParametersDescription
SQL Identification ValuesThe SQL ID value of the statement. 
Optimizer and Outline ValuesOptimizer-specific values pertaining to the parsing user ID value and outline SID. 
Parsing StatisticsInformation regarding memory, loads, and invalidation values. 
Execution Statistics

The execution statistics of the statement.

This category includes disk reads, buffer gets, rows, and values that represent CPU and elapsed time.

...

ValueNotes
StatementThe name of the statement. 
SQL IDThe ID value of the SQL statement. 
Child NumberThe child number in the database.
Parsing User IDThe ID of the user who parsed the statement. 
Plan Hash ValueThe execution value of the statement.
CPUCumulative CPU time for the process. (measured in "ticks", an arbitrary unit of time) 
Physical IOCumulative disk reads and writes for the process. (total count) 
Memory Usage

Number of pages in the procedure cache that are currently allocated to this process.

A negative number indicates that the process is freeing memory allocated by another process. 

ExecutionsThe number of times the statement was executed. 
Activity (%)A graphical representation of the distribution of execution and wait time for the statement or statement component. 

...

ValueNotes
User NameThe user name under which the session was run. 
ProgramThe name of the executable under which the session was run.
SIDThe SID value of the session.
Serial NumberThe 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. 
MachineThe machine name and network location of the machine from which the session executed. 
Session TypeThe 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
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse
Scroll pdf ignore
Automate SQL tuning and profiling with DB Optimizer. Learn more > >
IDERA WebsiteProductsPurchaseSupportCommunityAbout UsResources