From daemon Thu Feb 1 12:24:11 1996 Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65v3.0/1.1.8.2/01Aug94-0142PM) id AA07967; Thu, 1 Feb 1996 12:24:08 -0500 Message-Id: <9602011724.AA07967@alice.jcc.com> Received: from CCVM.SUNYSB.EDU by ccvm.sunysb.edu (IBM VM SMTP V2R3) with BSMTP id 2307; Thu, 01 Feb 96 12:03:47 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 4313; Thu, 1 Feb 1996 12:03:40 -0500 Date: Thu, 1 Feb 1996 12:00:12 GMT Reply-To: "ORACLE database mailing list." Sender: "ORACLE database mailing list." Comments: MEMO 02/01/96 12:03:00 From: David White Subject: Re: How to speed up parsing? X-To: ORACLE-L@ccvm.sunysb.edu To: Multiple recipients of list ORACLE-L Are you using rule or cost based optimization? If cost, then do both instances have accurate statistics? We've had problems with views using cost based optimizer. For the worst offenders, we alter the session so that it will run as rules based. David White dwhite@mccus.jnj.com ______________________________ Reply Separator _________________________________ Subject: How to speed up parsing? Author: ORACLEL (INTERNET.ORACLEL1) at ~SWIFTMAIL Date: 2/1/96 11:18 AM We've got numerous instances on our development/test machine. In one instance a select on a view parses in about 4 minutes. In another instance it takes over two (2) hours to parse. Both instances are running with the exact same init.ora parameters, and there is roughly the same amount of data (within 5%). Actually, the instance that parses the fastest has more data than the other instance. Any guidance as to what to look at to see why the parsing is taking so long would be greatly appreciated. For info, this is happening in Oracle Project Accounting, Apps 10.5, DB 7.1.6, Solaris 2.4. TIA. Jeff Weiss CMA Consulting Services, Inc.