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