Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 9272 invoked from network); 28 Dec 2007 18:03:10 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 28 Dec 2007 18:03:09 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 930BA7DE12D; Fri, 28 Dec 2007 19:03:10 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22346-10; Fri, 28 Dec 2007 19:03:10 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0B5177DE0BC; Fri, 28 Dec 2007 19:03:10 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 28 Dec 2007 18:15:45 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 22F9E7DD898 for ; Fri, 28 Dec 2007 18:15:45 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18296-09 for ; Fri, 28 Dec 2007 18:15:45 -0500 (EST) Received: from web51303.mail.re2.yahoo.com (web51303.mail.re2.yahoo.com [206.190.38.169]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id E852F7DD7A8 for ; Fri, 28 Dec 2007 18:15:44 -0500 (EST) Received: (qmail 89086 invoked by uid 60001); 28 Dec 2007 23:15:44 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=hlX7EeHbXRc80llqLT6dlNx8zK6arjYm+jkHtV46TjvL5VNNLg85TQNzCxijhiSjGWFMxgjSNg/8zuk01jQfJIeEhXx+gbdduTUgjkEFzGVG0V+Pr4kZe5TxNR6vShoQ13KjIudBHNDDQE7czcFBNxhnW2gH5tbCM06rMlVuKoc=; X-YMail-OSG: CShYCcsVM1nP8o_qJjfcIzFxuWUq_WxXJ9cJzDfQLeIX1M5C6CBFRnyf4bbkPjf60ttOBOJtiUmb6EsVBv.02m6t.VnZbAGDcgXUTGRaxqqx4rlRJu8zn1XYDPDGxMzRbeoQ4xyr18ZFuMfoTiYKghXMyQ-- Received: from [75.194.160.251] by web51303.mail.re2.yahoo.com via HTTP; Fri, 28 Dec 2007 15:15:44 PST Date: Fri, 28 Dec 2007 15:15:44 -0800 (PST) From: Sanjay Mishra Subject: Redo Log file and Buffer sizing To: oracle-l@freelists.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1524531324-1198883744=:87508" Message-ID: <220614.87508.qm@web51303.mail.re2.yahoo.com> X-archive-position: 4183 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: smishra_97@yahoo.com Precedence: normal Reply-to: smishra_97@yahoo.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain --0-1524531324-1198883744=:87508 Content-Type: text/plain; charset=us-ascii What are the good points to look in Oracle 10g R2 database so as to size the Redo Log file and Buffer. This is big OLTP database accessed heavily by more than 7000 concurrent users. Current Buffer is 130M and Log files is 500M. Logfiles are filled every 5-10minutes. What are the events as well as values that has to be checked to make sure it is working good or I can reduce/increase the Log buffer/redo log files. TIA Sanjay ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping --0-1524531324-1198883744=:87508 Content-Type: text/html; charset=us-ascii
What are the good points to look in Oracle 10g R2 database so as to size the Redo Log file and Buffer. This is big OLTP database accessed heavily by more than 7000 concurrent users. Current Buffer is 130M and Log files is 500M. Logfiles are filled every 5-10minutes. What are the events as well as values that has to be checked to make sure it is working good or I can reduce/increase the Log buffer/redo log files.
 
TIA
Sanjay

Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. --0-1524531324-1198883744=:87508-- -- http://www.freelists.org/webpage/oracle-l