|
-
 Originally Posted by dbbyleo
Then I decided to use 'disconnect'. This seemed to be really effective ... removing the session from v$session AND also removeing all the O/S process.
So I guess my reason question is ... why use 'kill' at all?
I don't believe it always works, meaning 'disconnect' doesn't always remove the session from v$session. 'disconnect' just closes the connection the session is using; the v$session entry will not go away unless the rollback is complete or the session is killed on OS level.
gtcol
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
|