decrease shared_pool size when creating large_pool

From: Jeffrey Beckstrom <>
Date: Fri, 21 Nov 2008 08:16:53 -0500
Message-Id: <>

I am looking at activating "shared servers" in one of our 9i instances. I am looking at an old document I have from when did this in 8i in 2004.  At that time, we decreased the size of the shared_pool when we created the large pool.  

I can not find anything on ML to explain why I would have done this? Do normal non-dedicated connections also use the large pool instead of the shared_pool for some storage? Any other ideas why the shared pool would have been cut in size?    

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

Received on Fri Nov 21 2008 - 07:16:53 CST

Original text of this message