Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

Archive for the ‘Oracle11gR2 Tuning’ Category

Managing Memory in Oracle11gR2

Posted by Hendry chinnapparaj on August 17, 2011

Specify a memory target covering the SGA and PGA – and then also the db cache and share pool size parms (as these change from being a setting to a lower limit when memory_target is set). This way it prevents the auto tuning from getting carried away with undersizing either of these.

memory_target            5,368,709,120
db_cache_size              805,306,368
shared_pool_size          805,306,368

Upon dumping the spfile contents to pfile the double underscore hidden parms show where these two are currently operating – you can see it is actually working at present with the shared pool being capped from going any lower:

__sga_target            3,489,660,928
__pga_aggregate_target    1,879,048,192

__db_cache_size        2,583,691,264
__shared_pool_size          805,306,368

__java_pool_size           16,777,216
__large_pool_size           33,554,432
__streams_pool_size           16,777,216
__shared_io_pool_size            0

Posted in Oracle11gR2 Tuning | Leave a Comment »