Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [10-2004 Date Index] [Date Next] || [Thread Prev] [10-2004 Thread Index] [Thread Next]

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

  • From: Smiley John - IL <SMILEYJ@xxxxxxxx>
  • To: 'Juan Carlos Reyes Pacheco' <jreyes@xxxxxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 1 Oct 2004 12:08:35 -0500
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@xxxxxxxxxxxxxxxx] 
Sent: Friday, October 01, 2004 11:35 AM
To: Smiley John - IL; oracle-l@xxxxxxxxxxxxx
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




[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.