Re: Tuning RMAN backup and recovery
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: don@xxxxxxxxx
- Date: Fri, 16 Nov 2007 09:37:22 -0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
