From oracle-l-bounce@freelists.org Tue Sep 21 13:18:04 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i8LII4k04556 for ; Tue, 21 Sep 2004 13:18:04 -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 i8LII3I04551 for ; Tue, 21 Sep 2004 13:18:03 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EC20472CE14; Tue, 21 Sep 2004 13:22:33 -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 13195-82; Tue, 21 Sep 2004 13:22:33 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 53C4172CD5C; Tue, 21 Sep 2004 13:22:33 -0500 (EST) Message-ID: Date: Tue, 21 Sep 2004 11:20:53 -0700 From: Jared Still To: esimmonds@speakeasy.net Subject: Re: OS Paging/performance question Cc: oracle-l@freelists.org In-Reply-To: <1095784998.2784.39.camel@trillian.myserenity.net> Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: <001001c49feb$d7827ac0$0a05a8c0@ddbc.local> <20040921150821.2385172CE55@turing.freelists.org> <1095784998.2784.39.camel@trillian.myserenity.net> X-archive-position: 9859 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org > I've done virus-scanning, adware checks, etc. > > Any other advice? > Pick a job that is running too slowly, and run 10046 trace on it. There are several tools available to analyze it, starting with tkprof. tkprof may provide you with enough ( more or less accurate ) information to pinpoint the problem, if the problem is slowly executing SQL. There are other pieces of information in the trace file as well. Try hotsos.com, ubtools.com and/or oraperf.com for detailed analysis of the file(s). HTH Jared -- http://www.freelists.org/webpage/oracle-l