AW: shared_io_pool

From: Petr Novak <Petr.Novak_at_trivadis.com>
Date: Wed, 10 Apr 2013 11:58:40 +0000
Message-ID: <09011014EB621E4CBC2536B62A1B64075AD9E648_at_smxc002.trivadis.com>



Hallo Pete,

thank you. But there are no secure files, only standard lobs.

Best Regards,
Petr




Von: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org]&quot; im Auftrag von &quot;Peter Hitchman [pjhoraclel_at_gmail.com] 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_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--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 10 2013 - 13:58:40 CEST

Original text of this message