|
 |
|
Oracle Tips by Burleson |
Profiler sample screen
The ease of use makes this a very good tool
when analyzing a trace file. It is also very helpful when
explaining to Developers why it is necessary to work with them on a
particular SQL statement or help them to change a coding practice.
Benefits of 10046 Tracing
Collecting and analyzing the data that can
be obtained by a 10046 trace provides specific information about the
performance of a specific session. This is often more beneficial
than looking at the v$ information since much of that information
can be from sessions that are not a key part of the performance
problem, or can be from earlier in the users sessions and have no
bearing on the current problem.
Limitations of 10046 Tracing
The Multi-Threaded Server (MTS) makes using
this process more difficult. Use of application servers that
establish “generic” connections to the database also limit the ease
with which this tool can be used.
Conclusion
This chapter has introduced 10046 Tracing
and the benefits that it brings to a tuning effort. The challenges
to collecting and interpreting this information were discussed.
Additionally, some of the resources available for facilitating this
were introduced:
The next
section of this book will go into more details on using Wait Event
information in practical ways to efficiently tune Oracle databases.
The above book excerpt is from:
Oracle Wait Event Tuning
High Performance with Wait
Event Iinterface Analysis
ISBN 0-9745993-7-9
Stephen Andert
http://www.rampant-books.com/book_2004_2_wait_tuning.htm |
