Re: Tuning RMAN backup and recovery

On Nov 15, 2007 2:53 PM, Don Seiler <don_at_seiler.us> wrote:
> I've read the tahiti doc of (nearly) the same name [0], but it really
> didn't do too much. I'm pretty sure I've posted about this but it's a
> high priority for me now.
>

Aside from compression, there are other things to consider.

Blocksize - this is used to set the buffer size in allocate channel maxfilesopen - going to disk the default (16 IIRC) is too high. Scale it down and test.
tape_io_slaves - the name may not be right, no db access at the moment. using tape IO slaves will cause the buffers to come from PGA rather than shared_pool (working from memory here, I believe that is accurate)
tape_async_io - yes, tapes are synchronous, but async is supported (see the docs)

Hotsos presentation coming up! :)

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l