Killed threads in session list
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Killed threads in session list

  1. #1
    Join Date
    May 2001
    Location
    Rome - Italy
    Posts
    24
    Hi all,
    I'm in Oracle 8i and W2000 platform,
    Why user threads in killed status still remain in the system session list and Oracle doesn't reuse the same SID, though several days are gone ?

    Thanks in advance.
    Fabio Arienzo
    Rome (Italy)

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Here is a thread that could help you. But I would suggest that you use the search Forums option on the top right corner of this page to search for issues on this. There are a number of good discussions on this issue. Pleas also take a look into it.

    http://www.dbasupport.com/forums/sho...threadid=10276

    Good luck,
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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