From oracle-l-bounce@freelists.org Wed Feb 25 04:21:40 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1PALcb27517 for ; Wed, 25 Feb 2004 04:21:38 -0600 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 i1PALco27512 for ; Wed, 25 Feb 2004 04:21:38 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B4D243950C4; Wed, 25 Feb 2004 05:03:23 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 25 Feb 2004 05:01:30 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from sql.spectranet.com (unknown [203.122.22.100]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 56CCE394F5D for ; Wed, 25 Feb 2004 05:01:23 -0500 (EST) Received: by SQL with Internet Mail Service (5.5.2650.21) id ; Wed, 25 Feb 2004 15:38:42 +0530 Message-ID: <91A92DA70CA5D5119C54000629054BA664815E@SQL> From: Arvind Kumar To: "'oracle-l@freelists.org'" Subject: wait event Date: Wed, 25 Feb 2004 15:38:41 +0530 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain; charset="iso-8859-1" X-archive-position: 1844 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: arvindk@sqlstarintl.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l hi list, what can be the reson for the wait event 'resmgr:wait in check2'.db is 9i release 1 on SUN server.when a user run a particular report that time the CPU usages goes upto 100% and if i see the v$session_wait ,the event is shown as 'resmgr:waiting in check2. Thanks Arvind ---------------------------------------------------------------- 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 -----------------------------------------------------------------