Home » RDBMS Server » Performance Tuning » db_cache_size
db_cache_size [message #65211] Mon, 14 June 2004 22:55 Go to next message
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.




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: 4578
Registered: April 1998
Senior Member

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.

Previous Topic: Batch Job performance.
Next Topic: Oracle 8.1.6 performance on NT4
Goto Forum:

Current Time: Fri Feb 23 16:15:32 CST 2024