Identifying the Session

[bang_dba]

Hi,

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.

[nagarjuna]

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..