Home » SQL & PL/SQL » SQL & PL/SQL » Identify my session
Identify my session [message #39803] Tue, 13 August 2002 02:14 Go to next message
Jens Vogelgesang
Messages: 23
Registered: January 2002
Junior Member
I need to get a clear identification of my session. I'm not sys or sysdba, ..

Is there a way to get something like pid or sid from my session. I will use this information to insert some information into a common.
Other way would be to use a sequence. But I would prefere ths 1st way.

Thanks Jens

Report message to a moderator

Re: Identify my session [message #39804 is a reply to message #39803] Tue, 13 August 2002 03:22 Go to previous messageGo to next message
jp
Messages: 11
Registered: August 2000
Junior Member
Hi jen,
Try whether this will help you

select sys_context('USERENV','SESSION_USERID') from dual;

-Regds
jose prakash

Report message to a moderator

Re: Identify my session [message #40132 is a reply to message #39804] Tue, 10 September 2002 23:34 Go to previous message
Jens Vogelgesang
Messages: 23
Registered: January 2002
Junior Member
Having 2 sql windows, I got the same result in both windows.
I expected different SID'S

Report message to a moderator

Previous Topic: Fixing Wrapped SYS Packages
Next Topic: Re: doubt
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 02 13:41:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.