RE: Row cache lock wait issue in RAC

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_at_gmail.com] Sent: Thursday, June 01, 2006 12:03 PM
To: Luca Canali
Cc: oracle-l_at_freelists.org
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