10g shared pool requirements

From: Christo Kutrovsky <kutrovsky.oracle_at_gmail.com>
Date: Wed, 4 May 2005 10:43:09 -0400
Message-ID: <52a152eb05050407433279a0e2@mail.gmail.com>

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?=20

--=20

Christo Kutrovsky
Database/System Administrator
The Pythian Group
--

http://www.freelists.org/webpage/oracle-l Received on Wed May 04 2005 - 10:47:33 CDT