| Session Identification [message #423437] |
Thu, 24 September 2009 03:47  |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
