Re: Tuning RMAN backup and recovery

Correction:
Tape IO slaves: set large pool, otherwise buffers come from shared pool.

No IO slaves: buffers in PGA

(Via blackberry)

On 11/16/07, Jared Still <jkstill_at_gmail.com> wrote:
> 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
>

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