Identifying the Session Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Identifying the Session

  1. #1
    Join Date
    Sep 2002

    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.

  2. #2
    Join Date
    Aug 2002
    Bangalore, India
    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..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width