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: Help me read my statspack report

Re: Help me read my statspack report

From: <emdproduction_at_hotmail.com>
Date: 15 Dec 2006 05:54:04 -0800
Message-ID: <1166190844.154577.243220@73g2000cwn.googlegroups.com>

> Ok, I see you have a distinct preference for symptom fighting, and
> following your own interpretations, instead of accepting advice from
> others.
> One might want to ask why you posted this at all, as you already know
> the solution.
> Yet I must warn you: you are using wrong criteria. It doesn't tell
> anything the top 5 sql executes in less than 20 seconds, what matters
> is the number of buffers it uses.
> Changing cursor_sharing to force also seldomly fixes anything, it makes
> sure the patient suffers less from terminal cancer, yet he still
> suffers from cancer.
> So if you want to continue to follow your own path, I won't block you,
> I just won't respond to any of your future posts.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Do not take me wrong. I really appreciate your help and took your advice to look for the TOP SQL from day one. Received on Fri Dec 15 2006 - 07:54:04 CST

Original text of this message

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