Home » RDBMS Server » Server Administration » Reconciling SGA_MAX_SIZE with other components (9.2.0.7)
Reconciling SGA_MAX_SIZE with other components [message #345035] Tue, 02 September 2008 03:16 Go to next message
nazbrian
Messages: 36
Registered: July 2008
Member
Following are my cace sizes

sort_area_size	           65536
olap_page_pool_size	   4194304
log_buffer	           10485760
shared_pool_reserved_size  30000000
large_pool_size	           167772160
java_pool_size	           167772160
db_cache_size	           167772160
shared_pool_size	   301989888
pga_aggregate_target	   1073741824
sga_max_size	           867135584


I'm not able to tally SGA_MAX_SIZE with other buffers.
What are the components I've to include to match with SGA_MAX_SIZE

I've considerd SGA_MAX_SIZE = shared_pool_size + db_cache_size + java_pool_size + large_pool_size + shared_pool_reserved_size + log_buffer + sort_area_size

Other caches like db_nk_cache_size are 0


Re: Reconciling SGA_MAX_SIZE with other components [message #345037 is a reply to message #345035] Tue, 02 September 2008 03:19 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The relation is:
SGA_MAX_SIZE >= shared_pool_size + db_cache_size + java_pool_size + large_pool_size + log_buffer

Regards
Michel
Previous Topic: Superset in characterset
Next Topic: out of process memory
Goto Forum:
  


Current Time: Thu Dec 08 14:41:15 CST 2016

Total time taken to generate the page: 0.16300 seconds