The v$session view can give you this information.
Tony Wang wrote in message ...
>Hi There,
>
>As a VB developer, I need to know how to obtain the
>sessionIDs that are currently connected to the Oracle Server.
>
>I can use USERENV('SESSIONID') to get my own sessionID,
>but not other sessions. If security is a essue to get these IDs,
>at least, I should get all the sessionIDs that belongs to me
>(the same userID).
>
>Please reply by email: Tonywzt_at_hotmail.com or reply this request.
>
>Thanks in advance for you help.
>
>Tony
>
>
>
Received on Sun Sep 26 1999 - 16:48:05 CDT
