Shared_pool

[Beejay]

Hi,

I wanaa Know when we say the performance can be increased by increasing the shared_pool size :- what exactly the size contribute its memory RAM or hard disk

Thanks
Bj

[drain surgeon]

The shared pool should be fully loaded in memory. If not paging and swapping will result and this is very bad for any Database.

If the shared pool is already in memory, and you have all the necessary procedures etc already pinned in the shared pool, then increasing the shared_pool_size will bring little benefit.

This will only result in you taking memory from the OS. Increasing the shared_pool_size means allocating RAM to the shared pool.

[Beejay]

THANK YOU DS FOR THE REPLY......

BJ

[Beejay]

Hi DJ One more things i want to know that if ram size is less , Is their any way to increase the Shared_pool_size performance

[drain surgeon]

Not that I know of. The bottom line is SGA must fit in memory or be prepared to put up with swapping and Paging. This will dramatically slow your database.