Re: how to find session id/serial no. of current session

Thanks to you all. I've tried the two methods

1). select * from v$mystat

and

2). select * from v$session where audsid=userenv('sessionid')

Both work, and they do require granting of different 'v_$' tables to public.

Regards

S S Wan

S S Wan wrote in message <615spi$hlp$1_at_tst.hk.super.net>...
>Does anybody know how to find the session id and serial number
>of the current session?
>
>Thanks.
>
>
Received on Tue Oct 07 1997 - 00:00:00 CDT