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 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
