Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Application, session and performance.
On 25.03.2007 03:41, Charles Hooper wrote:
> A 10046 trace can output wait events that are associated with the
> individual SQL statements between each COMMIT. This level of detail
> will likely be more useful to you when performance tuning the
> application than would the time deltas between the COMMITs. The wait
> events will tell you, for instance, if the delays are caused by client
> side processing, writing to the temp tablespace, index or table access
> (down to the file number and block, which may be used to determine the
> actual object causing the delay), etc. Each SQL statement will also
> include the total elapsed processing time and server CPU that was
> consumed.
>
> It takes some practice learning how to read 10046 trace files. Cary
> Millsap's "Optimizing Oracle Performance" is quite possibly the best
> resource for decoding 10046 trace files, but there are also a couple
> good articles on Metalink. While TKPROF can analyze 10046 trace
> files, much of the useful data contained in the trace file is either
> lost or reported out of scope. The 10046 trace file may report
> information like this:
<snip/>
For the purpose of this task (tuning) is there a difference between a 10046 trace and DBMS_SESSION.SET_SQL_TRACE / ALTER SESSION SET SQL_TRACE = TRUE? I did both in a brief test and it seems that trace file contents are mostly similar. Also, TKPROF processes both and seems to come up with a similar set of data. Granted I did not do fancy stuff, just some selects. Thanks!
Kind regards
robert Received on Mon Mar 26 2007 - 05:35:27 CDT