Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: dbms_session.unique_session_id for other sessions?

Re: dbms_session.unique_session_id for other sessions?

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Tue, 30 Aug 2005 17:17:17 +0200
Message-ID: <df1t9t$7dj$1@nntp.fujitsu-siemens.com> 





Mark D Powell wrote:


> Volker, where is your application getting the session id from?  Are you

> using dbms_session.unique_session_id or v$session.sid?

dbms_session.unique_session_id


But I just solved it. The same package also has a function that takes such
an id and checks whether the session is alive. So I can use that.



Since there are never more than five or so sessions, this is feasible.



Lots of Greetings and Thanks nevertheless!
Volker
Received on Tue Aug 30 2005 - 10:17:17 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US