Re: shared_io_pool
- From: Peter Hitchman <pjhoraclel@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 10 Apr 2013 12:38:05 +0100
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
Other related posts:
