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" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/18/2002 01:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]
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!
7-8.lst
Description: Binary data
