Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Please help, comment required urgently

Re: Please help, comment required urgently

From: chao_ping <>
Date: Sat, 19 Oct 2002 23:48:22 -0800
Message-ID: <>

I think the main performance bottleneck of your system is that your system is doing a lot of logical read than necessary. So, your cpu usage is rather high.
And you get a lot of latch free event for your wait event.

To get your system work better, i suggest you tune the sql with the most buffer_gets, which you can see from the statspack sql part. Tune the sql, use index scan etc.

This should help. I once met an exact case and finally tuned it via the sql

And your log buffer is huge, i think 256-3M is enough for most systems.

Good luck and hope your give back the feedback.

> Hi guys, I need a second opinion on the following Statspack output, I got my
> suspicions but my manager and the client is not buying what I am say,
> Not knowing anything of the system architecture please look at the output
> and say what would concern you. What assumptions/recommendations you would
> make.
> Thx
> George
> ________________________________________________
> George Leonard
> Oracle Database Administrator
> Dimension Data (Pty) Ltd
> (Reg. No. 1987/006597/07)
> Tel: (+27 11) 575 0573
> Fax: (+27 11) 576 0573
> Web:
> You Have The Obligation to Inform One Honestly of the risk, And As a Person
> You Are Committed to Educate Yourself to the Total Risk In Any Activity!
> Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
> or Injure Themselves as They See Fit!

Please see the official ORACLE-L FAQ:
Author: chao_ping

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Sun Oct 20 2002 - 02:48:22 CDT

Original text of this message