Hallo Pete, thank you. But there are no secure files, only standard lobs. Best Regards, Petr =================================== ________________________________________ Von: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx]" im Auftrag von "Peter Hitchman [pjhoraclel@xxxxxxxxx] Gesendet: Mittwoch, 10. April 2013 13:38 An: oracle-l Betreff: Re: shared_io_pool Hi From what I know this area of memory is to support I/O on securefile LOBs, so its size must depend on the workload, but I never seen any actual documentation about it. Regards Pete On 10 April 2013 09:53, Petr Novak <Petr.Novak@xxxxxxxxxxxx> wrote: > 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-- > //www.freelists.org/webpage/oracle-l > > > -- Regards Pete -- //www.freelists.org/webpage/oracle-l-- //www.freelists.org/webpage/oracle-l