Re: "Throttling" a session's IO

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 2 Apr 2007 09:52:04 -0700
Message-ID: <bf46380704020952m3ced06c5w8d37e710723af08@mail.gmail.com>

On 4/2/07, Hemant K Chitale <hkchital_at_singnet.com.sg> wrote:
>
>
> We have this Materialized View which generates more I/O when running
> the initial "DELETE" portion of a COMPLETE Refresh --- the DELETE
> generates
> a lot of UNDO and, more importantly, REDO (for the UNDO !).
>

You could make it do a TRUNCATE instead of a DELETE.

http://www.freelists.org/archives/oracle-l/01-2007/msg00666.html

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Apr 02 2007 - 11:52:04 CDT