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
