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

Thread: Identifying the Session

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    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.

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


Click Here to Expand Forum to Full Width