From oracle-l-bounce@freelists.org Fri Jun 18 18:11:10 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5INAtC14073 for ; Fri, 18 Jun 2004 18:11:05 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5INAj614059 for ; Fri, 18 Jun 2004 18:10:55 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D974C72C281; Fri, 18 Jun 2004 17:54:58 -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 18562-57; Fri, 18 Jun 2004 17:54:58 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2097072C258; Fri, 18 Jun 2004 17:54:58 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 18 Jun 2004 17:53:36 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6919A72C0A3 for ; Fri, 18 Jun 2004 17:53:36 -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 17943-60 for ; Fri, 18 Jun 2004 17:53:36 -0500 (EST) Received: from usscmail6.hds.com (usscmail6.hds.com [63.74.235.12]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E330C72C034 for ; Fri, 18 Jun 2004 17:53:35 -0500 (EST) Received: from mail.hds.com (usscmail8 [10.1.6.229]) by usscmail6.hds.com (8.11.5-p0-rfc19719/8.11.5) with ESMTP id i5INDqJ07450 for ; Fri, 18 Jun 2004 16:13:52 -0700 (PDT) Received: from usscceb02.corp.hds.com (usscclb02.hds.com [10.1.6.227]) by mail.hds.com (8.11.5-p0-rfc19719/8.11.5) with ESMTP id i5INCoh20521 for ; Fri, 18 Jun 2004 16:12:50 -0700 (PDT) Received: by usscceb02.hds.com with Internet Mail Service (5.5.2653.19) id ; Fri, 18 Jun 2004 16:12:23 -0700 Message-ID: <35CFD500D7BDCE43B9030BBA5979DC18015A3742@ussccem13.corp.hds.com> From: John Kanagaraj To: "'oracle-l@freelists.org'" Subject: RE: DBMS_STATS [resend chomped version] Date: Fri, 18 Jun 2004 16:14:17 -0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 3107 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: john.kanagaraj@hds.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Jonathan, >Agree completely - it's a bit of a luxury to have the time, >and hard to get the correct information, but every (complex) >system needs a table-driven stats gathering process to >minimize the work done, and maximise the return on effort. Someone on this list suggested (don't remember who) turning on Table monitoring on most (if not all) tables and using a script to analyze the top-N tables by 'staleness' (i.e. %age rows changed) in a cyclic fashion. This way, active tables would get analyzed more often while keeping down the system-load and avoiding a carpet-bomb type analyze. One of the questions then is the amount of overhead that MONITORING would place on the system - in the SGA as well as on processing. My very sketchy understanding (based on Steve Adams' website) is that the updates to the in-memory structures behind DBA_TAB_MONITORING is unlatched and not overhead-heavy. However, there was no hard evidence. Do you have any? Is this data collected off the mechanism that updates values in V$SQL? [Apps has a _lot_ of tables (about 15,000), although some of them may be inactive based on what modules have been implemented] Any thoughts on this welcome! John Kanagaraj <>< DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevitable, but Discouragement is optional! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------