From oracle-l-bounce@freelists.org Fri Aug 12 15:35:10 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j7CKZ94c013844 for ; Fri, 12 Aug 2005 15:35:09 -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 j7CKZ6IP013824 for ; Fri, 12 Aug 2005 15:35:07 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9CF211DD78F; Fri, 12 Aug 2005 15:34:59 -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 23041-08; Fri, 12 Aug 2005 15:34:59 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EE9011DD966; Fri, 12 Aug 2005 15:34:58 -0500 (EST) In-Reply-To: <8FB2C86BB1EB01498A59A762F6CD556F02502B47@MAPI.iconnection.com> To: Joe.Sweetser@i-structure.com Cc: oracle-l@freelists.org, oracle-l-bounce@freelists.org Subject: RE: Oracle/Windows question MIME-Version: 1.0 Message-ID: From: "Leandro Guimaraes Faria C. Dutra" Date: Fri, 12 Aug 2005 17:28:56 -0300 X-MIMETrack: Serialize by Router on TDBKDD08/TDB(Release 6.5.1|January 21, 2004) at 08/12/2005 05:24:51 PM, Serialize complete at 08/12/2005 05:24:51 PM Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis X-archive-position: 23902 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ldutra@toyota.com.br Precedence: normal Reply-To: ldutra@toyota.com.br 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.7 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 oracle-l-bounce@freelists.org gravou em 2005-08-12 17:06:34: > A few more questions: Would the size of the data set being operated on > have any bearing on the memory usage? Yes, within the bounds of the configuration you did. That is, with less memory there'll be less cache, less buffers, and consequently more disk accesses. > I saw on Metalink Note:271072.1 that the init.ora processes has no > impact on this situation because it doesn't take in any resources. > Agreed? Actually, this note is about listeners. init.ora configures the server. So you can allocate enough in init.ora that you won't get all the listeners you want. > If my best immediate solution is to reduce the size of the SGA and I > have these values set (I inherited this db so can't address why values > where changed): > shared_pool_size = 300000000 #previous value: 40000000 > shared_pool_reserved_size = 3000000 #previous value: 2000000 > log_buffer = 1048576 #previous value: 163840 > any idea where I might get the most "bang for the buck"? You must monitor for your specific situation... but the biggest influence in SGA is db_cache_size. -- Leandro Guimarães Faria Corcete DUTRA Administrador de Bases de Dados +55 (11) 4390 5383 Toyota do Brasil Ltda ldutra@toyota.com.br São Bernardo do Campo, SP BRASIL This message (including any attachments) is confidential and may be privileged and intended solely for the use of the person/entity to whom it is addressed. If you have received it by mistake please notify the sender by returning via e-mail as well as delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is prohibited. Please note that e-mails are susceptible to change. TOYOTA DO BRASIL LTDA (including its group companies) shall not be liable for the improper or incomplete transmission of the information contained in this communication, neither for personal, nonbusiness related information nor opinion sent through this email or even for any delay in its receipt or damage to your system. TOYOTA DO BRASIL LTDA (or its group companies) does not guarantee that the integrity of this communication has been kept nor that this communication is free of viruses, interceptions or interference. -- http://www.freelists.org/webpage/oracle-l