Jeremiah Wilton wrote:
>
> Both of these work, but are inefficient for repeated frequent use by
> an application:
>
> select sid from v$session where audsid= userenv('sessionid');
> select sid from v$mystat where rownum = 1;
>
> This is the most efficient:
>
> select ksusenum from x$ksumysta w
-Original Message-
Sent: Wednesday, December 19, 2001 1:16 PM
To: Multiple recipients of list ORACLE-L
Why not just:
select sid from v$session
where audsid= userenv('sessionid');
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORA
Both of these work, but are inefficient for repeated frequent use by
an application:
select sid from v$session where audsid= userenv('sessionid');
select sid from v$mystat where rownum = 1;
This is the most efficient:
select ksusenum from x$ksumysta where rownum = 1;
You need to be SYS or have
Way much better :)
Thanks. I forgot about mystat view..
- Kirti
-Original Message-
Sent: Wednesday, December 19, 2001 3:12 PM
To: [EMAIL PROTECTED]
select distinct SID from v$mystat;
"Deshpande, Kirti" wrote:
>
> Try this:
>
> select sid from v$session
> where audsid=(select user
Why not just:
select sid from v$session
where audsid= userenv('sessionid');
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 19, 2001 3:50 PM
> Try this:
>
> select sid from v$session
Try this:
select sid from v$session
where audsid=(select userenv('sessionid') from dual);
- Kirti
-Original Message-
Sent: Wednesday, December 19, 2001 1:36 PM
To: Multiple recipients of list ORACLE-L
Hi
How do find own session id?
Thanks
-sEEMA
__
Subject: WHICH SID
Hi
How do find own session id?
Thanks
-sEEMA
_
Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp.
--
Please see the of
Hi
How do find own session id?
Thanks
-sEEMA
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
INET: [EMAIL PROT