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
-
]
Sent: Friday, October 18, 2002 2:53 AM
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 pleas
Thanks for your contributions on this Tim (and on everything else you
respond to).
These little tips of how to analyze statspack reports properly all add up
and whilst I did look at the report and I did glean some of you what
suggested I certainly did not pick up all that you spotted
John
To give credit where credit is due...
I've never bothered to learn how to interpret a STATSPACK report; I've left
that with what little I ever knew about interpreting a BSTAT/ESTAT report.
Rather, I just send the report to the YAPP report post-processor at
www.oraperf.com and it formats
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
:
Subject:Re: Please help, comment required urgently
To give credit where credit is due...
I've never bothered to learn how to interpret a STATSPACK report; I've
left
that with what little I ever knew about interpreting a BSTAT/ESTAT report.
Rather, I just send the report
18, 2002 7:53 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Please help, comment required urgently
George,
Two things jump out together:
* The SQL statement with hash value = 3509998681 is consuming about
25% of the total response-time (i.e. total processing plus
PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Friday, October 18, 2002 7:53 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Please help, comment required urgently
George,
Two things jump out together:
* The SQL statement with hash value = 3509998681 is consuming about
25