Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 16419 invoked from network); 22 May 2007 22:44:51 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 22 May 2007 22:44:51 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 90F9C6E68D3; Tue, 22 May 2007 23:43:01 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27234-02; Tue, 22 May 2007 23:43:01 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 02F356E68B5; Tue, 22 May 2007 23:43:00 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 22 May 2007 23:03:20 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9072B6E6FDC for ; Tue, 22 May 2007 23:03:20 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24199-06 for ; Tue, 22 May 2007 23:03:20 -0400 (EDT) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 30BFC6E5EE8 for ; Tue, 22 May 2007 23:03:19 -0400 (EDT) Received: by ug-out-1314.google.com with SMTP id t39so404456ugd for ; Tue, 22 May 2007 20:05:09 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=NU5VsT/07OSUSELYQAjb6wGEG2wHOsBQmC6vorQZOmeHt63HHCBLJ1ninXN0WdZh0Pn1QBG2MMkjQCId3pi3yebCGLyan5Z9Brj0L5hpXyvTbJV2G7ERyuGxp45oRwUSUzeITCQvA4DIJz6Fdr4iEh/fNoWVZOWbH1G7HoIUil4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=lYfmDzVCA5VKyDyfJQu0QB+dbiKfno/jKUajnD1UOY4AT5t03nF6NmrghQpUNCwZjIz//efSXFnu1pnxATPf1FVNDX9TSN7+XYfV7yv/PoC7r5VVSc9F0fYSGduwO8MXuoFzYPdZomBjXxiEBJXmK5sLFQ/m5jqkofjkkqyFJtE= Received: by 10.67.29.7 with SMTP id g7mr1051231ugj.1179889509126; Tue, 22 May 2007 20:05:09 -0700 (PDT) Received: by 10.66.220.19 with HTTP; Tue, 22 May 2007 20:05:09 -0700 (PDT) Message-ID: Date: Tue, 22 May 2007 23:05:09 -0400 From: Tanmoy To: oracle-l@freelists.org Subject: Finding orphan sessions MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1051_13698999.1179889509084" X-archive-position: 49261 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: tanmoydc@gmail.com Precedence: normal Reply-to: tanmoydc@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_Part_1051_13698999.1179889509084 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi, We have a requirement where we need to find the Orphan session in DB. Well, it happened some time back when one of our job get killed after reaching its max time, but it's thread processes were running, so we need a monitoring sql to check such process who does not have any parent. Possible ? -- Regards, Tanmoy -- "Time is the coin of life. Only you can determine how it will be spent." ------=_Part_1051_13698999.1179889509084 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hi,
 
      We have a requirement where we need to find the Orphan session in DB. Well, it happened some time back when one of our job get killed after reaching its max time, but it's thread processes were running, so we need a monitoring sql to check such process who does not have any parent.
 
      Possible ?

--
Regards,
Tanmoy

-- "Time is the coin of life. Only you can determine how it will be spent."

 
------=_Part_1051_13698999.1179889509084-- -- http://www.freelists.org/webpage/oracle-l