Q: How to obtain SID for my session?

From: Stan Benda <sbenda_at_uswest.com>
Date: Fri, 10 Aug 2001 15:58:20 -0500
Message-ID: <AVXc7.925$3R1.249122_at_news.uswest.net>

Closest I found is

select userenv(sessionid) from dual;

but it is audit ID. I would like to find SID or serial# for v$session

Stan Received on Fri Aug 10 2001 - 22:58:20 CEST

This message: [ Message body ]
Next message: Guang Mei: "Re: How to obtain SID for my session?"
Previous message: JohnyS: "Re: Oracle Under Debian Stable"
Next in thread: Guang Mei: "Re: How to obtain SID for my session?"
Reply: Guang Mei: "Re: How to obtain SID for my session?"
Reply: Kevin McDaniel: "Re: Q: How to obtain SID for my session?"
Reply: Sybrand Bakker: "Re: Q: How to obtain SID for my session?"
Maybe reply: padderz: "Re: Q: How to obtain SID for my session?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message