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: Kevin Closson <kevinc_at_polyserve.com>
Date: Wed, 15 Mar 2006 14:41:26 -0800
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD06FE4C6@ex2.ms.polyserve.com>


>>>I don't have a solution with the existing technology. This
>>>sounds like an excellent performance enhancement request to
>>>Oracle. They shouldn't need to write dirty buffers for the
>>>table being truncated, but they will need to be marked
>>>non-dirty or invalid

Is there evidence that the dirty buffers are being written? It should only shoot down the buffers in each SGA. Depending on what is going on at the time, that can be quite expensive... certainly if there are 1 million buffers in 4 RAC instances... That is a lot of chain walking

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 15 2006 - 16:41:26 CST

Original text of this message

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