Re: Row cache lock wait issue in RAC

  • From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
  • To: <Luca.Canali@xxxxxxx>
  • Date: Thu, 1 Jun 2006 12:03:03 +0200

I am using Oracle 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.



Other related posts: