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

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/10/04
Message-ID: <343787f1.50325103@newshost>#1/1

On Sun, 5 Oct 1997 01:04:35 +0800, "S S Wan" <sswan_at_hk.super.net> wrote:

>Does anybody know how to find the session id and serial number
>of the current session?
>
>Thanks.
>

select sid, serial# from v$session where audsid = userenv('sessionid');

will do it....

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Oct 04 1997 - 00:00:00 CDT