Re: 10g shared pool requirements
- From: Christo Kutrovsky <kutrovsky.oracle@xxxxxxxxx>
- To: Rich.Jesse@xxxxxxxxxxxxxxxxx
- Date: Wed, 4 May 2005 14:06:36 -0400
The evidence I have is the shared pool errors we have :)
The other evidence i have is my v$sgastat output:
select pool, name,round(bytes/1024/1024) as mb from v$sgastat order by
pool,bytes desc;
java pool free memory 16
large pool free memory 15
large pool PX msg pool 1
shared pool sql area 370
shared pool library cache 223
shared pool miscellaneous 148
shared pool free memory 87
shared pool partitioning d 60
shared pool KGLS heap 34
shared pool KQR M PO 30
shared pool KQR M SO 24
shared pool KQR L PO 17
shared pool PL/SQL MPCODE 6
shared pool PL/SQL DIANA 3
shared pool type object de 3
shared pool KUPP subheap 1
shared pool KQR L SO 1
shared pool repository 0
shared pool parameters 0
shared pool PX subheap 0
shared pool STREAMS messag 0
shared pool pl/sql source 0
shared pool PLS non-lib hp 0
shared pool table definiti 0
shared pool PL/SQL PPCODE 0
shared pool trigger defini 0
shared pool evaluation con 0
shared pool KQR S SO 0
shared pool joxs heap 0
shared pool kwqbsinfy:bqgc 0
shared pool fixed allocation callback 0
shared pool trigger inform 0
shared pool kwqbsinfy:stat 0
shared pool kwqbsinfy:cco 0
shared pool image handles: 0
shared pool kwqbsinfy:bmsg 0
buffer_cache 992
fixed_sga 1
log_buffer 1
On 5/4/05, Jesse, Rich <Rich.Jesse@xxxxxxxxxxxxxxxxx> wrote:
> As Moe Syzslak would say, "WHAAAA??!??!"
>=20
> 1) What evidence do you have that you require 600MB of shared pool?
>=20
> 2) Are you using ASMM?
>=20
> I've got a small-ish 10.1.0.3.0 DB dedicated to Oracle's Ultra Search =3D
> and it runs very happy with a 250MB total SGA on Solaris 9. Currently, =
=3D
> ASMM has 145MB of that for the shared pool, 60 for Java, and 40 for =3D
> buffers.
>=20
> Rich
>=20
> Rich Jesse System/Database Administrator
> rich.jesse@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA
> =3D20
>=20
>=20
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> Sent: Wednesday, May 04, 2005 9:43 AM
> To: oracle-l
> Subject: 10g shared pool requirements
>=20
> Hello,
>=20
> We've been testing some of our systems with 10g. We frequenly run (on
> multiple different environments) into shared pool issues.
>=20
> The solution so far has been to increase the shared pool size.
> Databases that used to have < 100 Mb shared pool, now require 600 Mb
> of shared pool to run. And those are small developement boxes.
>=20
> What are your observation on 10g shared pool usage?=3D3D20
>=20
> --=3D3D20
> Christo Kutrovsky
> --
> //www.freelists.org/webpage/oracle-l
>=20
--=20
Christo Kutrovsky
Database/System Administrator
The Pythian Group
--
//www.freelists.org/webpage/oracle-l
Other related posts:
