Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h9AF9ZY08737 for ; Fri, 10 Oct 2003 10:09:36 -0500 X-ClientAddr: 66.27.56.210 Received: from ns3.fatcity.com (rrcs-west-66-27-56-210.biz.rr.com [66.27.56.210]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h9AF9Zc08732 for ; Fri, 10 Oct 2003 10:09:35 -0500 Received: from ns3.fatcity.com (localhost.localdomain [127.0.0.1]) by ns3.fatcity.com (8.12.8/8.12.8) with ESMTP id h9ACNQf5030683 for ; Fri, 10 Oct 2003 05:26:01 -0700 Received: (from root@localhost) by ns3.fatcity.com (8.12.8/8.12.5/Submit) id h9ABtP8L025936 for oracle-l@orafaq.net; Fri, 10 Oct 2003 04:55:26 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D2B47; Fri, 10 Oct 2003 04:54:25 -0800 Message-ID: Date: Fri, 10 Oct 2003 04:54:25 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "VIVEK_SHARMA" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "VIVEK_SHARMA" Subject: Optimizer related init parameters Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPartTM-000-faa1ec34-003b-48de-a8a4-db577a5ae6b1" ------=_NextPartTM-000-faa1ec34-003b-48de-a8a4-db577a5ae6b1 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C38F24.2E6BFED0" ------_=_NextPart_001_01C38F24.2E6BFED0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable How Good/advisable are the following 4 parameters' Values in a Hybrid Application? Are there any know ill-effects of the same? =20 Application - Banking (Hybrid) Solaris 9=20 Oracle 9.2=20 =20 =20 optimizer_max_permutations=3D8000 optimizer_index_cost_adj=3D10 optimizer_index_caching=3D50 optimizer_dynamic_sampling=3D4 =20 =20 =20 Some INFO :- Database has 6000 Concurrent Users accessing=20 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 =20 Will Give any info required =20 Thanks =20 =20 =20 ------_=_NextPart_001_01C38F24.2E6BFED0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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=3D8000
 optimizer_index_cost_adj=3D10
 optimizer_index_caching=3D50
 optimizer_dynamic_sampling=3D4

 

 

 

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

 

 

 

=00 ------_=_NextPart_001_01C38F24.2E6BFED0-- ------=_NextPartTM-000-faa1ec34-003b-48de-a8a4-db577a5ae6b1-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: VIVEK_SHARMA@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@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).