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

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