Re: WHICH SID

2001-12-19 Thread Stephane Faroult
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

RE: WHICH SID

2001-12-19 Thread Steve McClure
-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

RE: WHICH SID

2001-12-19 Thread Jeremiah Wilton
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

RE: WHICH SID

2001-12-19 Thread Deshpande, Kirti
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

Re: WHICH SID

2001-12-19 Thread Igor Neyman
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

RE: WHICH SID

2001-12-19 Thread Deshpande, Kirti
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 __

RE: WHICH SID

2001-12-19 Thread Boivin, Patrice J
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

WHICH SID

2001-12-19 Thread Seema Singh
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