DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.