Re: dbms_session (unique_session_id)

You can check V$_MYSTAT view: select SID from V$_MYSTAT where rownum = 1 returns the current session ID

Fernando (morgan_at_cardume.com)
CardumeSoftware
www.cardume.com

Bill Brady <bbrady_at_sql-tech.com> wrote in article <3336BC5F.1F58_at_sql-tech.com>...
> Can anyone tell me if the session id returned from this function is
> available through one of the v$..... tables. We use this to track open
> connections to the database to facilitate switching between the
> connections but when a connection terminates abnormally the cleanup
> doesn't occur in the "tracking" table, therefore the need to view active
> sessions.
>
> Bill
>
Received on Thu Mar 27 1997 - 00:00:00 CST