From oracle-l-bounce@freelists.org Wed Mar 23 19:01:27 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j2O11Q4s012224 for ; Wed, 23 Mar 2005 19:01:26 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j2O11Pem012220 for ; Wed, 23 Mar 2005 19:01:25 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0C73B87FDB; Wed, 23 Mar 2005 18:59:37 -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 11146-08; Wed, 23 Mar 2005 18:59:36 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 80E6188016; Wed, 23 Mar 2005 18:59:36 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=lPJ6a/gRI2hnezx9UILa6IQjH8qtxL7RAV7XtU9G80VpDiFbKolgZQWzTQZhg/lBinV4me/IKfXfA2yJ2Z/Z+PXHLmNasrNCwJSBac8oZdoupRxjjBExSWJ+5l9YavPoWBuBI2TcklGR6zk7vuF1ZBW7RPBPhCyNYO0DAZZpKGM= Message-ID: <910046b405032315576a1c8437@mail.gmail.com> Date: Wed, 23 Mar 2005 18:57:48 -0500 From: Paul Drake To: rjamya@gmail.com Subject: Re: v$lock question Cc: Oracle Discussion List In-Reply-To: <9177895d05032312523c7b1682@mail.gmail.com> Mime-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit References: <9177895d05032312523c7b1682@mail.gmail.com> X-archive-position: 17668 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: bdbafh@gmail.com Precedence: normal Reply-To: bdbafh@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.1 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: try hanganalyze instead. less filling. finally found my first "unable to extend segment in by n bytes" message in 9.2 today. That was a pretty good run without one. Paul On Wed, 23 Mar 2005 15:52:14 -0500, rjamya wrote: > for lock type 'CU' what do values id1 and id2 indicate? > > We had a developer experience DBDS (death by dynamic sql). The session > is waiting on 'global cache cr request' waiting for more than 3000 > seconds, 10046 trace file doesn't get updated, and v$lock shows type > 'CU'. > > BTW using oradebug to dump processstate for the process in question > doesn't work, I had to kill the dump processstate command after 4 > minutes. So, I dumped the systemstate and found some more information. > > So once again the question is what do the values of id1 and id2 > indicate for lock type 'CU'. > > After looking 'CU' I had developer put in 'cs=exact' in the code and > the report finished in expected time (as against 5 hours and > counting). > > I am just curious I guess. > TIA > Raj > ------------------------------ > select standard_disclaimer from company_requirements where category = > 'MANDATORY'; > -- > http://www.freelists.org/webpage/oracle-l > -- #/etc/init.d/init.cssd stop # f=ma, divide by 1, convert to moles. -- http://www.freelists.org/webpage/oracle-l