|Home • Trainings • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
Understanding SQL Trace
By Aveek Ghose, IBM India
an SQL Trace:
Screen shot of the initial ST05 screen
clicking list trace
The basic list trace shows the
sequence of database operations that are taking place while a query is
processed, it includes prepare, fetch, open, reopen, execute. In addition the
basic list trace also gives the duration execution for each of the operations
with color legend.
the basic trace list (menu path: Goto à Summary)
A basic trace list can be
summarized to see the summation of execution times of similar database
operations. Use menu path: GotoàSummary.
The above screen shot depicts the summed up execution time. The summary option
lists the summed up execution time of all the queries that the SQL trace has
captured at its runtime, but the identification of a particular query can be
done using the PID – Process ID which
is displayed as the first column of the above screen shot. For example,
896 is the process ID for one of the SQL statements.
of a particular trace
To get the total execution time,
specifically for a particular SQL Statement, select all the PID
corresponding to it and click summarize in the application toolbar. This
leads to a compressed data of SQL trace as above.
legends indicating the processes in a trace 1
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards