Home » RDBMS Server » Server Administration » Session Identification (oracle,windows)
Session Identification [message #423437] Thu, 24 September 2009 03:47 Go to next message
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%'"


[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: 65135
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Current Time: Wed Aug 16 21:04:51 CDT 2017

Total time taken to generate the page: 0.10960 seconds