parameters
- From: Murtuja Khokhar <murtuja_oracle@xxxxxxxxx>
- To: freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 21 Sep 2006 07:06:40 -0700 (PDT)
I have Oracle9i Enterprise Edition Release 9.2.0.1.0 on Solaris 10.
I have set sga_max_size = 2 GB.
and db_block_size=8192
Now My question is what will the value of below parameters
so I can allocate maximum memory to each parameter
db_cache_size
db_keep_cache_size
db_recycle_cache_size
buffer_pool_keep
buffer_pool_recycle
global_context_pool_size
java_pool_size
large_pool_size
olap_page_pool_size
shared_pool_reserved_size
shared_pool_size
bitmap_merge_area_size
create_bitmap_area_size
hash_area_size
sort_area_retained_size
sort_area_size
Please guide me with this.
Thanks in Advance
---------------------------------
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates
starting at 1¢/min.
Other related posts:
