Re: Select Current Session ID ?

On Feb 11, 7:08 am, Cassiano <cassianorol..._at_gmail.com> wrote:
> Hi
>
> How I can select *my* current session id (from v$session?) in sqlplus?
>
> Thanks

Apart from using the v$mystat view (available in 9i and later releases)

select sid
from v$session
where audsid = sys_context('USERENV', 'SESSIONID');

Presuming you have access to the V$SESSION view.

David Fitzjarrell Received on Mon Feb 11 2008 - 14:36:25 CST