Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Truncating tables in RAC environment

Re: Truncating tables in RAC environment

From: rjamya <rjamya_at_gmail.com>
Date: Wed, 15 Mar 2006 12:00:15 -0500
Message-ID: <9177895d0603150900vf3c8e7as463531ed6ec4e532@mail.gmail.com>


I don't know your definition of long time to truncate. I don't see much of a problem in a two node RAC. BTW to those interested, KGopal mentioned on the list some time ago that truncating GTTs is a very very expensive operation in RAC, should be avoided.

Raj

On 3/15/06, Hameed, Amir <Amir.Hameed_at_xerox.com> wrote:
> Folks,
> It seems that truncating a table under RAC is more expensive than
> truncating it under a single instance because of the dictionary cache
> synchronization. We converted a single instance to a three-node RAC and
> for those jobs that truncate tables during processing, the 10046 trace
> files show "DFS lock handle" wait. The tables that get truncated are
> staging/intermediate tables and sometimes they contain a lot of rows and
> therefore a delete command can take a long time to finish. On the other
> hand a few seconds DFS wait is still much better than the wait that a
> blind delete will cause. But I was wondering if there was a better way
> to avoid/minimize this wait.
>
> Thanks
> Amir
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
----------------------------------------------
Got RAC?
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 15 2006 - 11:00:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US