|
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
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
|
- Re: Optimizer related init parameters VIVEK_SHARMA
- Re: Optimizer related init parameters Jared Still
- Re: Optimizer related init parameters Gaja Krishna Vaidyanatha
- RE: Optimizer related init parameters VIVEK_SHARMA
- RE: Optimizer related init parameters Gaja Krishna Vaidyanatha
