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 same
update on UAT
environment works at a rate
Hello ALL,
Oracle ver is 9.2 running on EMC array. I am executing a pl/sql
procedure which does an update on a fact table. There is an unique
index on the fact, with clearly shows up in the explain plan for
udapte.
I ran 10046 event for a 18 min duration during this update process and
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
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
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
