gt; From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 17, 2003 11:49 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: sequential waits -- how to proceed
>
>
> Thanks for your reply ...
>
> I understand that it is a sql per row update but the s
Does the UAT have the same data volume, same nr of rows and blocks in the
table being updated?
At 08:49 PM 6/17/2003 -0800, you wrote:
Thanks for your reply ...
I understand that it is a sql per row update but the same update on UAT
environment works at a rate of
about 2000 rows per sec. Though
Thanks for your reply ...
I understand that it is a sql per row update but the same update on UAT
environment works at a rate of
about 2000 rows per sec. Though the data volume is definetly less
compared to PROD, still there is night and day difference between prod
and uat..In terms of the tables
Your pl/sql procedure is obviously doing a sql per row updated rather than
a set update. Unless you change the procedure you can expect only marginal
improvement from any other measure.
At 03:29 PM 6/17/2003 -0800, you wrote:
Hello ALL,
Oracle ver is 9.2 running on EMC array. I am executing