RE: Truncating tables in RAC environment
- From: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 15 Mar 2006 14:41:26 -0800
>>>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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
