The Difference Bewteen Kill Session and Disconnect Session in Oracle Database

smallwei 10:28 am on November 23, 2009 | Answers: 1    
Tags: bewteen, difference (13), kill (2), oracle (106), session (2)

Rate Knowledge: (1 votes)

 Loading ...

• smallwei 10:28 am on November 23, 2009
  

  Kills a session:
  Releases locks and other resources but keeps the session object so that the application gets a graceful “ora-28, you have been KILLED, goodbye” message from the server.

  the session is dead, killed, resources released. However the session remains — this is so the client process which is still connected can report gracefully to the end user “your session was killed, goodbye”. What happened was that user had a session opened (maybe a sqlplus session). It was just sitting there — and would continue to sit there until it went to the database — then the session would actually “disappear” — after the client got the message.

  Disconnect session:
  Disconnect is primarily for TAF (failing over), so you can fail a connection over from one
  instance to another. you can have it do that after the transaction ends so as to not lose work.
  Disconnecting zaps the dedicated server, and the client does not get a nice message.