Hello George I think that you need to tune the first statement the do the most gets and the most i/o. The same statement also access the most rows. It is fired up about every 5 seconds and is very resource consuming.
I am not a tuning expert but this is my 0.01$ worth. Yechiel Adar Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, October 18, 2002 10:53 AM > 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! > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
