Re: Row cache lock wait issue in RAC

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Thu, 1 Jun 2006 12:03:03 +0200
Message-ID: <027601c68562$92fd7090$1a03310a@MPILA9>

> 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

Received on Thu Jun 01 2006 - 05:03:03 CDT