Re: Q: How to obtain SID for my session?
From: padderz <member_at_dbforums.com>
Date: 13 Aug 2001 08:15:11 -0500
Message-ID: <3b77c4cf$1_at_usenetgateway.com>
Date: 13 Aug 2001 08:15:11 -0500
Message-ID: <3b77c4cf$1_at_usenetgateway.com>
Try...
SELECT sid, serial# FROM v$session WHERE audsid = USERENV('SESSIONID');
-- Padderz SYSOP, RevealNet PL/SQL Pipeline Oracle Developer, Cellular Operations UK Posted via dBforums http://dbforums.comReceived on Mon Aug 13 2001 - 15:15:11 CEST