Home » RDBMS Server » Server Administration » Session Identification (oracle 10.2.0.4.0,windows)
Session Identification [message #423437] Thu, 24 September 2009 03:47 Go to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Hi all,

How to identify which session (SID) im currently using in SQLPLUS tool
when there are more than one session is opened with same username.

In this case both the sessions are in ACTIVE session.


Below is the query which shows ,what are all sessions that are currently opened
with username 'MOHAN' .But i want to know which session im currently using .

"select username,status,sid,serial# from v$session where upper(program)
like '%SQLPL%'and upper(username) like '%MOHAN%'"
/


Regards,


[Updated on: Thu, 24 September 2009 03:53]

Report message to a moderator

Re: Session Identification [message #423443 is a reply to message #423437] Thu, 24 September 2009 04:00 Go to previous message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
sys_context('userenv','sid')

Regards
Michel
Previous Topic: ORA-01092: ORACLE instance terminated. Disconnection forced
Next Topic: why commit doesnt make dbwr to write in datafile?
Goto Forum:
  


Current Time: Sat Oct 01 09:15:33 CDT 2016

Total time taken to generate the page: 0.04586 seconds