RE: 10g shared pool requirements

As Moe Syzslak would say, "WHAAAA??!??!"

1) What evidence do you have that you require 600MB of shared pool?

2) Are you using ASMM?

I've got a small-ish 10.1.0.3.0 DB dedicated to Oracle's Ultra Search =
and it runs very happy with a 250MB total SGA on Solaris 9.  Currently, =
ASMM has 145MB of that for the shared pool, 60 for Java, and 40 for =
buffers.

Rich

Rich Jesse                        System/Database Administrator
rich.jesse@xxxxxxxxxxxxxxxxx      QuadTech, Sussex, WI USA
=20



-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
Sent: Wednesday, May 04, 2005 9:43 AM
To: oracle-l
Subject: 10g shared pool requirements


Hello,

We've been testing some of our systems with 10g. We frequenly run (on
multiple different environments) into shared pool issues.

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.

What are your observation on 10g shared pool usage?=3D20

--=3D20
Christo Kutrovsky
--
http://www.freelists.org/webpage/oracle-l

Other related posts: