Re: can huge updates cause locks
- From: Database Admin <dba@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 9 Mar 2004 12:28:40 +0530 (IST)
Yes ,I am sure they do,so do I .But my question was "ON PEAK TIME" when
all the users are accessing this table.I tried this yesterday during peak
load
(simulated) around 6.10 avg on the said box and the system became slow as a
snail.Plz read the last line I mentioned "IS THERE ANYTHING I AM MISSING".If
you know that plz tell me.
Deep
>
> 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
> -----------------------------------------------------------------
----------------------------------------------------------------
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:
