From oracle-l-bounce@freelists.org Thu Mar 11 09:48:45 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2BFmjb23489 for ; Thu, 11 Mar 2004 09:48:45 -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 i2BFmio23483 for ; Thu, 11 Mar 2004 09:48:44 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7E99C394ADA; Thu, 11 Mar 2004 09:45:24 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 11 Mar 2004 09:44:10 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from ext-ch1gw-5.online-age.net (ext-ch1gw-5.online-age.net [64.37.194.13]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 66F62394958 for ; Thu, 11 Mar 2004 09:44:07 -0500 (EST) Received: from int-ch1gw-3.online-age.net (int-ch1gw-3 [3.159.232.67]) by ext-ch1gw-5.online-age.net (8.12.9/8.12.9/990426-RLH) with ESMTP id i2BEmrdK011954 for ; Thu, 11 Mar 2004 09:48:54 -0500 (EST) Received: from uswaumsxb1medge.med.ge.com (localhost [127.0.0.1]) by int-ch1gw-3.online-age.net (8.12.9/8.12.3/990426-RLH) with ESMTP id i2BEmqSx027851 for ; Thu, 11 Mar 2004 09:48:53 -0500 (EST) Received: by uswaumsxb1medge.med.ge.com with Internet Mail Service (5.5.2656.59) id ; Thu, 11 Mar 2004 08:48:52 -0600 Message-ID: <1C9727B12F498543A43CBB988F30515C029B7E54@uswaumsx14medge.med.ge.com> From: "Kommareddy, Srinivas (MED, Wissen Infotech)" To: oracle-l@freelists.org Subject: RAC gv$session Date: Thu, 11 Mar 2004 08:48:46 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2656.59) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C40777.F4D34849" X-archive-position: 493 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Srinivas.Kommareddy@med.ge.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C40777.F4D34849 Content-Type: text/plain; charset="iso-8859-1" Hi All, We have 2 nodes set for RAC. When I try to kill a session from node 1, is the sid,serial# going to be unique among the nodes, Or is there any possibility that another session on node 2 will be killed (if sid, seiral# are same for another session on node 2). Does my select sid,serial# checks v$session or gv$session. Can someone through some light on this. Tx and Regards, Srinivas ------_=_NextPart_001_01C40777.F4D34849 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi = All,

 

We have 2 nodes set for = RAC.

 

When I try to kill a = session from node 1, is the sid,serial# going to be = unique among the nodes,

Or is there any = possibility that another session on node 2 will be killed (if sid, seiral# are same for another session on node = 2).

 

Does my select sid,serial# checks v$session or = gv$session.

 

Can someone through some = light on this.

 

Tx and = Regards,

Srinivas

------_=_NextPart_001_01C40777.F4D34849-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------