Oracle-L: Re: Please help, comment required urgently

From: <Jared.Still_at_radisys.com>
Date: Fri, 18 Oct 2002 09:05:00 -0800
Message-ID: <F001.004ED8C8.20021018090500@fatcity.com>

What would concern me is the 99.x% buffer cache hit ratio along with an apparently huge number of LIO's per second.

This database is spinning its wheels, due to poor SQL and/or poorly written procedural code.

That's my 30 second analysis. :)

Is this a commercial or custom app?

Jared

"Leonard, George" <george.leonard_at_farnell.com> Sent by: root_at_fatcity.com
10/18/2002 01:53 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Please help, comment required urgently

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
E-mail:george.leonard_at_za.didata.com
Web: http://www.didata.co.za

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!

Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.

This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.

--=_mixed 0057F77A88256C56_=--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).



application/octet-stream attachment: 7-8.lst

Received on Fri Oct 18 2002 - 12:05:00 CDT