Using AUDSID to identify a session

From: Pascal Waterkeyn <pwk_at_offis.be>
Date: Mon, 21 Jun 1999 14:08:05 +0200
Message-ID: <7kl9sb$i3$1@news3.Belgium.EU.net>

I am using the V$SESSION dynamic performance table in a package in order to determine if a certain session is still valid, or if the user has been disconnected.

In order to identify the session, I use the AUDSID because I can easily get the value for the current session using USERENV('SESSIONID').

My question is: can I safely use the AUDSID value to identify a session, or in other words, is the AUDSID unique within an instance ?

If you suggest me to use the SID and/or SERIAL# instead, please indicate how I can easily get the values for the current session.

Thanks.

Pascal Received on Mon Jun 21 1999 - 07:08:05 CDT