RE: V_$SESSION question

From: <Rick_Cale_at_teamhealth.com>
Date: Tue, 12 Feb 2002 05:20:12 -0800
Message-ID: <F001.0040C744.20020212043820@fatcity.com>

Depending on how you want to see SID. If you want to see the SID name then do

SELECT instance FROM v$thread;

Also a little cleaner method then below IMHO SELECT sid FROM v$mystat WHERE rownum=1;

Rick

                                                                                       
                            
                    "Mark Leith"                                                       
                            
                    <mark_at_cool-to        To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>       
                    ols.co.uk>           cc:                                           
                            
                    Sent by:             Subject:     RE: V_$SESSION  question         
                            
                    root_at_fatcity.                                                      
                            
                    com                                                                
                            
                                                                                       
                            
                                                                                       
                            
                    02/12/2002                                                         
                            
                    06:08 AM                                                           
                            
                    Please                                                             
                            
                    respond to                                                         
                            
                    ORACLE-L

A quick and easy way, though there may be better or even easier ways that the list will no doubt tell us about..

select distinct sid from v$mystat;

HTH Mark

-----Original Message-----

Ghadge,Sameer
Sent: 12 February 2002 09:53
To: Multiple recipients of list ORACLE-L

Hi,
my problem is as follows:
I want do determine the machine name (and other info) from pl/sql,of the client from which i have logged in
e.g. suppose i have logged from machine 'power_machine' as user 'puser' my pl/sql has info. that the current user 'puser'

How do i retrive my sid for this session, which is in V_$SESSION.

so basically i want the SID of the current session Thx
Sameer

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ghadge,Sameer
INET: Sameer_Ghadge_at_Syntelinc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mark Leith
INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Rick_Cale_at_teamhealth.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message