Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Sql Tuning

Re: Sql Tuning

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 20 Aug 2006 15:58:53 -0700
Message-ID: <1156114732.884847@bubbleator.drizzle.com>


Sybrand Bakker wrote:
> On 20 Aug 2006 10:06:06 -0700, "Raaj" <erkraj_at_gmail.com> wrote:
>

>> Hi all,
>>       Could anyone tell me about, how to interpret the top 5 wait
>> events and how to retrieve datas fast, like high throughput for users.
>> I am new to Oracle DBA..
>>
>> Regards,
>> Raaj

>
> As any event can occur in the top 5, do you want to be educated about
> all of them?
> If so, wouldn't it be more advisable for you to read the Performance
> Tuning Manual for your version, or the book on the Oracle Wait
> Interface published by Oracle Press, or the book by Cary Millsap on
> Optimizing Oracle Performance?
>
> --
> Sybrand Bakker, Senior Oracle DBA

In addition to Cary's book also pick up a copy of Jonathan Lewis' book on the CBO: http://www.apress.com/book/bookDisplay.html?bID=10081

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Aug 20 2006 - 17:58:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US