how to find the sid from v$session of my current session as soon as it make connection with DB [message #537364] |
Tue, 27 December 2011 23:49 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/4b90acb41f786e62dff67ac96e54c5e0?s=64&d=mm&r=g) |
kiran111
Messages: 49 Registered: October 2011
|
Member |
|
|
Hi Experts,
Need your advice in how to find the sid from v$session of my current session.
I want to ask:
Let say I have open 10 TOAD session and only in one toad session i have fired a sql query ( the rest 9 session are just blank), then the rest 9 status are in inactive status.
Now, how i can figure out which sid ( from v$session ) belongs to which session as all the 9 session having nothing to run.
Quote:My main intention is to find out the current session sid as soon as it make connection with DB.
Thanks
|
|
|
|
|
|
|
|
|
|