Xref: alice comp.databases.oracle.server:48247
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!dispose.news.demon.net!demon!colt.net!Pollux.Teleglobe.net!newsserver.pacific.net.sg!not-for-mail
From: Prabhakar Narayanan <prabhakar.narayanan@clsasia.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: How to identify my session?
Date: Wed, 05 May 1999 17:01:11 +0800
Organization: Subscriber of Pacific Internet 
Message-ID: <373008D7.39E76290@clsasia.com>
References: <372fd681.104203747@news.seed.net.tw>
Mime-Version: 1.0
Content-Type: multipart/mixed;
 boundary="------------979E66075A53ED2D93FE77DC"
X-Mailer: Mozilla 4.5 [en] (Win98; I)
X-Accept-Language: en
To: Brahms Lin <sw@feya.com.tw>
Lines: 49
--------------979E66075A53ED2D93FE77DC
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi

Issue the following statement to find out your session id

select userenv('sessionid') from dual

Regards

N.Prabhakar

Brahms Lin wrote:

> Hi,
>
> I would like to find some way to identify my Oracle app's session.
> I know there's a v$session, but don't know which is my current
> session. I'm trying to generate an unique table name. I think that
> can be done by prefixing the current session's id to the table name.
>
> Thanks.
>
> (Oracle 8.0.4 on NT workstation 4.0)

--------------979E66075A53ED2D93FE77DC
Content-Type: text/x-vcard; charset=us-ascii;
 name="prabhakar.narayanan.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Prabhakar Narayanan
Content-Disposition: attachment;
 filename="prabhakar.narayanan.vcf"

begin:vcard 
n:Narayanan;Prabhakar
tel;work:65 439 5862
x-mozilla-html:FALSE
org:Credit Lyonnais Securities Singapore Pte Ltd;Technology
version:2.1
email;internet:Prabhakar.Narayanan@clsasia.com
title:Mr.
adr;quoted-printable:;;32nd Floor=0D=0AHitachi Tower;Singapore;;;Singapore
end:vcard

--------------979E66075A53ED2D93FE77DC--