Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Retrieve information from v$session for current user.
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
Received on Sun Apr 05 1998 - 00:00:00 CST