Re: How to find PID in a session

Try,

SELECT DBMS_SESSION.UNIQUE_SESSION_ID FROM DUAL HTH, Philippe

Werner wrote in message <36DBA5AE.27BD_at_face.co.zackityspam>...
>Hello
>
>I would like to find a unique way of identifying a session in my log
>file.
>
>If the user Werner log in 10 times, I would like to keep his log entries
>seperate.
>
>I was hoping to use UID with a "Select uid from dual" but it is always
>the same for the same user.
>
>"Select PID from dual" does not want to work. Is there any other easy
>way of finding PID? Or will
>I have to use some random number to identify each session ?
>
>
>Help will be appreciated.
>
>PS: The log files I am talking about, is being updated programmatically.
>
>Thanks
>Werner
Received on Tue Mar 02 1999 - 04:21:25 CST