From oracle-l-bounce@freelists.org Mon Aug 8 14:45:40 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j78Jje6m016327 for ; Mon, 8 Aug 2005 14:45:40 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j78JjcIP016311 for ; Mon, 8 Aug 2005 14:45:38 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2F5151DD4F5; Mon, 8 Aug 2005 13:52:27 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19213-01; Mon, 8 Aug 2005 13:52:27 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 87F011DD4ED; Mon, 8 Aug 2005 13:52:26 -0500 (EST) Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.326 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: Buffer gets increase in massive execution Date: Mon, 8 Aug 2005 11:51:56 -0700 Message-ID: <04DDF147ED3A0D42B48A48A18D574C45023613F7@NT15.oneneck.corp> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Buffer gets increase in massive execution thread-index: AcWcSZi9DxXsbwX1QjKmmgA8GvKC1QAAGZ7A From: "Allen, Brandon" To: , "oracle-l" X-archive-position: 23585 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Brandon.Allen@OneNeck.com Precedence: normal Reply-To: Brandon.Allen@OneNeck.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.8 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 Sounds like different explain plans between the two executions. Do you have different system stats for different periods (OLTP/batch) of the day? Are you changing optimizer_mode or any other parameters in your batch process? Do you have a smaller arraysize in your batch process? -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Alfonso León Sent: Monday, August 08, 2005 11:46 AM To: oracle-l Subject: Buffer gets increase in massive execution Hi: I have a batch process that executes individual transactions, normally a transaccion e.g. a simple select would take 8-10 buffer gets but in the batch processing it takes 45 buffer gets. Any ideas in the explanation? TIA -- Alfonso Leon -- http://www.freelists.org/webpage/oracle-l Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. -- http://www.freelists.org/webpage/oracle-l