-
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
-
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.
-
THANK YOU DS FOR THE REPLY......
BJ
-
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
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|