Re: decrease shared_pool size when creating large_pool
Date: Sat, 22 Nov 2008 15:37:48 -0800 (PST)
> 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
Could that be related to the fact that before 10g, a server process in shared server config uses UGA for sorting and hashing and UGA comes from large pool (unless large pool is not configured)? See http://yong321.freeshell.org/oranotes/LargePoolMtsPga.txt
Since the physical memory of a box is fixed, when you create large pool and if you don't want to increase SGA, you can shrink shared pool or buffer cache accordingly. But I think there's advice that you go the other way, i.e. *increase* shared pool when you run shared server config.
Yong HuangReceived on Sat Nov 22 2008 - 17:37:48 CST