db_cache_size [message #65211] |
Mon, 14 June 2004 22:55 |
Joy
Messages: 21 Registered: November 2001
|
Junior Member |
|
|
Dear All,
Can anyone let me know (thumb rule) how much should be the value of db_cache_size, shared_pool_size as a percentage of physical RAM in both OLTP and hybrid system.
Thanks,
joy
|
|
|
Re: db_cache_size [message #65215 is a reply to message #65211] |
Tue, 15 June 2004 05:55 |
Frank Naude
Messages: 4587 Registered: April 1998
|
Senior Member |
|
|
Hi,
It depends on the application(s)/users using the database. Use the provided advisories (v$db_cache_advice, v$shared_pool_advice, etc.) to determine if you need to increase or decrease allocated memory. Also, watch system paging and swapping so you don't over allocate these areas.
Best regards.
Frank
|
|
|