From oracle-l-bounce@freelists.org Mon Jul 26 10:35:39 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6QFZEU26063 for ; Mon, 26 Jul 2004 10:35:24 -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 i6QFZ3626001 for ; Mon, 26 Jul 2004 10:35:14 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 93D3272C87E; Mon, 26 Jul 2004 10:13: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 32243-18; Mon, 26 Jul 2004 10:13:36 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E162C72C01A; Mon, 26 Jul 2004 10:13:35 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 26 Jul 2004 10:12:11 -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 9936972C35A for ; Mon, 26 Jul 2004 10:12:10 -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 30585-57 for ; Mon, 26 Jul 2004 10:12:10 -0500 (EST) Received: from [63.71.63.1] (corporate.LifeTouch.com [63.71.63.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 3492772C308 for ; Mon, 26 Jul 2004 10:12:10 -0500 (EST) Received: from no.name.available by [63.71.63.1] via smtpd (for [206.53.239.180]) with SMTP; 26 Jul 2004 15:43:30 UT Received: (private information removed) Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00AB1@EXCHMN3> From: DENNIS WILLIAMS To: "'oracle-l@freelists.org'" Subject: RE: Statspack Report Date: Mon, 26 Jul 2004 10:35:22 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-type: text/plain; charset=iso-8859-1 X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 5990 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: DWILLIAMS@LIFETOUCH.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Kevin The two sources I'm aware of, aside from the Oracle documentation, are the series of Oracle Magazine articles and Don Burleson's book Oracle9i High-Performance Tuning with STATSPACK. Also, be aware of the limitation of STATSPACK. Statistics are aggregated in two dimensions - by time (the interval you take snapshots) and by all processes on the system. Cary Millsap does a great job of pointing out the limitations of methods that perform these aggregations. My personal analogy is: "You can drown in a river that is only an average of three feet deep". Dennis Williams DBA Lifetouch, Inc. "We all want progress, but if you're on the wrong road, progress means doing an about-turn and walking back to the right road; in that case, the man who turns back soonest is the most progressive." -- C.S. Lewis -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Kevin Lange Sent: Monday, July 26, 2004 10:10 AM To: 'oracle-l@freelists.org' Subject: Statspack Report Evening; Does there happen to be any 'definitive' set of documentation on interpreting the reports given out by Statspack ? I just set it up for the first time and could use any 'direction' on what is the best documentation set for it. Thanks Kevin ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------