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

 

 

 

Reply via email to