Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> can huge updates cause locks

can huge updates cause locks

From: Database Admin <dba_at_magma.co.in>
Date: Mon, 8 Mar 2004 16:24:49 +0530 (IST)
Message-ID: <24922.172.16.7.252.1078743289.squirrel@www.magma.co.in>


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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Mon Mar 08 2004 - 04:38:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US