Optimizer related init parameters

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Fri, 10 Oct 2003 04:54:25 -0800
Message-ID: <F001.005D2B47.20031010045425@fatcity.com>

How Good/advisable are the following 4 parameters' Values in a Hybrid Application?

Are there any know ill-effects of the same?  

Application - Banking (Hybrid)

Solaris 9

Oracle 9.2    

 optimizer_max_permutations=8000
 optimizer_index_cost_adj=10
 optimizer_index_caching=50
 optimizer_dynamic_sampling=4

 

 

 

Some INFO :-

Database has 6000 Concurrent Users accessing

We do ONLY INDEX Scans with exceptional FTS .

FTS if present occur only on SMALL Tables (a few Hundred Rows)

FTS if unchecked greatly harm our performance

Stripe Unit Size 64K

Oracle Block Size 8K  

Will Give any info required  

Thanks      

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: VIVEK_SHARMA
  INET: VIVEK_SHARMA_at_infosys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Oct 10 2003 - 07:54:25 CDT