FreeLists / oracle-l / RE: Row cache lock wait issue in RAC

["Luca Canali" <Luca.Canali@xxxxxxx>]

Hi Dimitre,

I am using direct path insert, which writes above the HWM. I cannot
preallocate space in the table for that.

Regards,
L.

-----Original Message-----
From: Radoulov, Dimitre [mailto:cichomitiko@xxxxxxxxx] 
Sent: Thursday, June 01, 2006 12:03 PM
To: Luca Canali
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Row cache lock wait issue in RAC

> I am using Oracle 10.2.0.2 with RAC (6 nodes ) + ASM on RHEL 3. I use 
> LMT bigfile tablespaces and ASSM. I am aware of the exchange partition

> bug, but my case looks different: I don't seem to have any deadlocks 
> and using the workaround you mention (fixed quotas) did not help.

If you preallocate the storage, you'll avoid the updates on tsq$.

Try insert/truncate reuse storage and reinsert, the waits have to
disappear.
So if you know the regular size of the tables, you could prepare the
storage.


Regards
Dimitre 

--
http://www.freelists.org/webpage/oracle-l