RE: Please, Which events are usefull in optimizaing out than 10 0 46 from 10 000 to 20 000

The best source of information I've ever seen on how to interpret a 10046 trace is Cary's "Optimizing Oracle Performance". You might also find MetaLink Notes 39817.1 and 224270.1 useful.

The OWI: A Practical Guide... is a fantastic source of information Oracle Wait Interface tuning.

I suggest reading the OWI book first to get an intro to OWI, then read Cary's book to get deep into 10046 tracing (as well as some very useful grounding in queuing theory).

John

-----Original Message-----

From: Juan Carlos Reyes Pacheco [mailto:jreyes_at_dazasoftware.com] Sent: Friday, October 01, 2004 11:35 AM
To: Smiley John - IL; oracle-l_at_freelists.org Subject: RE: Please, Which events are usefull in optimizaing out than 10 046 from 10 000 to 20 000

Thanks a lot John,

2. Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning, Shee

Is this an specialized book for trace like Millsap's book? Do you know another book specialized in interpreting trace and dump files.

I'm looking for them

Thanks  

Juan Carlos Reyes Pacheco
OCP
--

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 01 2004 - 12:04:10 CDT