Re: Tuning RMAN backup and recovery

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: don@xxxxxxxxx
  • Date: Fri, 16 Nov 2007 13:23:54 -0800

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@xxxxxxxxx> wrote:
> On Nov 15, 2007 2:53 PM, Don Seiler <don@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l


Other related posts: