From oracle-l-bounce@freelists.org Mon Jul 26 16:50:56 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6QLofq17447 for ; Mon, 26 Jul 2004 16:50:51 -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 i6QLoV617357 for ; Mon, 26 Jul 2004 16:50:41 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B61E372DE88; Mon, 26 Jul 2004 16:29:01 -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 20886-41; Mon, 26 Jul 2004 16:29:01 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DC85972CCAD; Mon, 26 Jul 2004 16:29:00 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 26 Jul 2004 16:27:23 -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 E5CEA72D9D0 for ; Mon, 26 Jul 2004 16:26:40 -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 19541-61 for ; Mon, 26 Jul 2004 16:26:40 -0500 (EST) Received: from tera.umi.com (tera.umi.com [192.195.245.144]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2C66372D9C7 for ; Mon, 26 Jul 2004 16:26:40 -0500 (EST) Received: from aabo-exchange04.bos.il.pqe (aabo-exchange04.bos.il.pqe [172.24.3.67]) by tera.umi.com (8.12.10/8.12.10) with ESMTP id i6QLr1MS008019 for ; Mon, 26 Jul 2004 17:53:23 -0400 Received: from bosmail00.bos.il.pqe ([172.24.3.64]) by aabo-exchange04.bos.il.pqe with Microsoft SMTPSVC(6.0.3790.0); Mon, 26 Jul 2004 17:53:29 -0400 X-MIMEOLE: Produced By Microsoft Exchange V6.0.6556.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: RE: Moving to 9i..... Date: Mon, 26 Jul 2004 17:53:29 -0400 Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF09660C44@bosmail00.bos.il.pqe> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Moving to 9i..... Thread-Index: AcRzWhrW+glnSGBUS4exxXIjIysC8gAAL0hg From: "Bobak, Mark" To: X-OriginalArrivalTime: 26 Jul 2004 21:53:29.0646 (UTC) FILETIME=[FCA9E4E0:01C4735A] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 6074 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Mark.Bobak@il.proquest.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Nope, checked that: SQL> show parameter statistics NAME TYPE VALUE ------------------------------------ ----------- = ------------------------------ statistics_level string TYPICAL timed_os_statistics integer 0 timed_statistics boolean TRUE Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Post Hoc Ergo Propter Hoc" -----Original Message----- From: oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org] On Behalf Of Tanel P=F5der Sent: Monday, July 26, 2004 5:46 PM To: oracle-l@freelists.org Subject: Re: Moving to 9i..... > For some reason, Oracle is doing LOTS more system calls. I tried > trussing a couple of the hot server processses, I see lots and lots of > poll(), pread() and times() sys calls. Inside the db, this translates > to lots and lots of latch free on cache buffers chains and library > cache. But, I suspect that it's secondary due to the CPU staravtion > caused by the heavy syscall activity. Do you have timed_os_statistics enabled? (if statistics_level =3D all = then timed_os_statistics defaults to true...) Tanel. ---------------------------------------------------------------- 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 -----------------------------------------------------------------