Re: can huge updates cause locks
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 08 Mar 2004 21:37:27 +0800
What is your "hypothetical" explanation for why a single user with a 5000
row
update causes ITL Waits and Latch Misses and "slowly but surely cripple
the system" ? Are you sure about the "surely" ?
A 5000 row update isn't necessarily going to cripple your system.
Many people run xthousands of rows updates frequently on databases.
Hemant
At 04:24 PM 08-03-04 +0530, you wrote:
Hi,
First of all let me clarify this is a Hypothecal Situation.
Suppose there is a table x which houses important piece of transaction
data.Now this box happens to be a HP-UX 11.11,Dual Proc,4GB RAM Oracle
9.2.0.1 Box having 200 users.Now say one of the users suddenly at peak
load period starts updating this table with 5000 new rows,my idea is
it will cause immediate ITL Waits,Latch Misses and slowly but surely cripple
the system.As the ITL waits will have a rippling effect I would expect
ORA-60 to turn up in the alert<sid>.ora .
Will you plz let me knw if I am correct or there is something I am missing
alltogether.
Thanks
Deep
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com {last updated 24-Jan-04}
"If you wish to leave your footprints on the sand, do not drag your feet"
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
