parameters

From: Murtuja Khokhar <murtuja_oracle_at_yahoo.com>
Date: Thu, 21 Sep 2006 07:06:40 -0700 (PDT)
Message-ID: <20060921140640.10747.qmail@web32706.mail.mud.yahoo.com>

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.
--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 21 2006 - 09:06:40 CDT