From: "ami" <ami_gon@netvision.net.il>
Subject: Re: Retrieve information from v$session for current user.
Date: 1998/04/05
Message-ID: <6g8ogl$5k0$1@news.netvision.net.il>#1/1
References: <01bd5bfa$57135bc0$4553a4a7@w00128433> <6frubj$iu9$1@nnrp1.dejanews.com>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: NetVision LTD.
Newsgroups: comp.database.oracle,comp.databases.oracle.misc



you can also get information like this way :
select * from v$session where paddr in (select addr from v$process where
spid =xxxxx);
where xxxxx is the oracle server process id