OraFAQ Forum: Server Administration » Reconciling SGA_MAX

Home » RDBMS Server » Server Administration » Reconciling SGA_MAX_SIZE with other components (9.2.0.7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Reconciling SGA_MAX_SIZE with other components [message #345035]

Tue, 02 September 2008 03:16

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

Report message to a moderator