From oracle-l-bounce@freelists.org Wed Sep 14 02:17:28 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8E7HSTU030151 for ; Wed, 14 Sep 2005 02:17:28 -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 j8E7HN6H030136 for ; Wed, 14 Sep 2005 02:17:23 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2723A1EBC8D; Wed, 14 Sep 2005 02:17:19 -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 05971-01; Wed, 14 Sep 2005 02:17:19 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7A2241EB8D2; Wed, 14 Sep 2005 02:17:18 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=ZYtCdlkM7eNiIlcgDplJ61BPKWmBr4Ri4xqUT+Q2JeFTuCUd7w5NGGPhVvLjmwy2wD1wgbX+LI8r91L/9WN6CBoeXgQMmvle5wGX0ql4hcf17HQ5a/7K8ijVb2ScNySZAPCLAz1AgBVqpifm1BuEZ3hFOght9f9y+RcldiRQf6A= Message-ID: <97b7fd2f05091400154421f844@mail.gmail.com> Date: Wed, 14 Sep 2005 10:15:24 +0300 From: The Human Fly To: Oracle-L Freelists Subject: index + table monitoring performance 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 Content-Disposition: inline X-archive-position: 25406 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: sjaffarhussain@gmail.com Precedence: normal Reply-To: sjaffarhussain@gmail.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=-2.9 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 Friends, We have the utter most critical database in the bank which is used for share trading appliction. The database runs on AIX 5.2L OS with 12 cpu and 24GB of RAM. SGA is around 3GB and PGA is 2.4 GB. We are planning to enable index monitoring on application schema, this schema is heavily accessed during trading hours, i.e. 3 hrs. in the morning and 3 hrs. in the evening, though its 24x7 database, and number of transaction per second are 120. Could you please shed some lime light or suggest us as per your experience that enabling index monitoring cause any performance degradation? Because, even 5% of performance degradation is un acceptable. Please lets us know the pros and cons of enabling index monitoring. We also planning to enable table monitoring on this schema to collect statistics on table which has STALE statistics. Does this effect the performance? Thank you in advance -- Best Regards, Syed Jaffar Hussain OCP 8i & 9i DBA, Banque Saudi Fransi, Saudi Arabia ---------------------------------------------------------------------------------------- "It is your atittude, not your aptitude that determins your altitude." -- http://www.freelists.org/webpage/oracle-l