Home » RDBMS Server » Performance Tuning » db_cache_size
db_cache_size [message #65211] Mon, 14 June 2004 22:55 Go to next message
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 Go to previous message
Frank Naude
Messages: 4579
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
Previous Topic: Batch Job performance.
Next Topic: Oracle 8.1.6 performance on NT4
Goto Forum:
  


Current Time: Fri Mar 29 08:53:00 CDT 2024