Identifying the Session
I have opened 4 sql sessions, on same machine and executing 4 queries.
All 4 queries take long time to come out.
In the mean time i want to kill one window, due to some reasons and keep other 3 running.
How to distinguish session id of this window to kill the same, since i have opened all the windows on same terminal.
combine the v$session, v$open_cursor views for sid columns, terminal column of v$session and and sql_text columns of v$open_cursor to get the exact SID..
Click Here to Expand Forum to Full Width