RAC gv$session

From: Kommareddy, Srinivas (MED, Wissen Infotech) <Srinivas.Kommareddy_at_med.ge.com>
Date: Thu, 11 Mar 2004 08:48:46 -0600
Message-ID: <1C9727B12F498543A43CBB988F30515C029B7E54@uswaumsx14medge.med.ge.com>

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

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_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

---

Received on Thu Mar 11 2004 - 09:48:45 CST