Re: How do I get _my_ session id?

Try one of the following:

select sid from sys.v$session where audsid = userenv('sessionid');

or:

select distinct sid from sys.v$mystat

Marc

Helmut Hahn wrote:
>
> Andreas Dunker wrote:
>
> > Hi *,
> >
> > how do I get the session id of the current connection;
> > for example in sqlplus
> >
> > select something from someviewortable;
> >
> > Andreas
> >
Received on Tue Oct 13 1998 - 10:42:19 CDT