shared_io_pool
- From: Petr Novak <Petr.Novak@xxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 10 Apr 2013 08:53:49 +0000
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
Other related posts:
