shared_io_pool

From: Petr Novak <Petr.Novak_at_trivadis.com>
Date: Wed, 10 Apr 2013 08:53:49 +0000
Message-ID: <09011014EB621E4CBC2536B62A1B64075AD9E5F3_at_smxc002.trivadis.com>



Hallo ,

after upgrade from 10G to 11.2.0.3 DB allocated 430M of shared_io_pool

 select
   ksppinm,
   ksppstvl,
   ksppstdvl
from

   x$ksppcv a,
   x$ksppi b
where

   a.indx=b.indx
and

   b.ksppinm like '%shared_io%';

KSPPINM                        KSPPSTVL             KSPPSTDVL
------------------------------ -------------------- ---------------

__shared_io_pool_size 452984832 432M
_shared_io_pool_size 0 0
_shared_iop_max_size 536870912 512M
_shared_io_pool_buf_size 1048576 1M
_shared_io_pool_debug_trc 0 0
_shared_io_set_value FALSE FALSE

What possibilities are to set upper boundary of shared_io_pool ? With setting _shared_iop_max_size ? Did anybody play with these parameters ? How it is possible to monitor if (and how effective, impact on performance ) this pool is used ? Why the DB allocated such pool ? We have other 11G DBs , also with LOBs , where such pool ist not present.

Best Regards,
Petr--
http://www.freelists.org/webpage/oracle-l Received on Wed Apr 10 2013 - 10:53:49 CEST

Original text of this message