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

Home -> Community -> Usenet -> c.d.o.server -> Re: switching to 'direct path read' should help prevent thrashing buffer cache ?

Re: switching to 'direct path read' should help prevent thrashing buffer cache ?

From: Valentin Minzatu <valentinminzatu_at_yahoo.com>
Date: 22 Dec 2006 07:27:15 -0800
Message-ID: <1166801235.826929.161380@i12g2000cwa.googlegroups.com>


I am not sure if this is feasible in your case: have you considered moving the specific columns to a separate table and truncating it instead of updating? Alternatively, have you considered partitioning the table such way that you can truncate one partition at a time?

Valentin Received on Fri Dec 22 2006 - 09:27:15 CST

Original text of this message

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