Re: shared_io_pool

From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Wed, 10 Apr 2013 12:38:05 +0100
Message-ID: <CAPMSPxMU4SJdqHKt6dL3bdc3B7T9ZQ7hbwQ6dRqF6AwHvf800Q_at_mail.gmail.com>

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_at_trivadis.com> 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--
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Regards

Pete


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 10 2013 - 13:38:05 CEST