Re: dbms_session (unique_session

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 1997/03/25
Message-ID: <5h7urd$il7@info.csufresno.edu>#1/1

In article <3336BC5F.1F58_at_sql-tech.com>, Bill Brady <bbrady_at_sql-tech.com> wrote:
>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.

There is a v$session table, and three of the 32 columns are: saddr (raw), sid (number), and audsid (number). Hope this is what you are looking for.

Regards,
Steve Cosner Received on Tue Mar 25 1997 - 00:00:00 CST

Re: dbms_session (unique_session_id)