-
Identifying the Session
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.
-
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..
-nagarjuna
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|