Databases Reference
In-Depth Information
POST_TRANSACTION : This option leaves the user session alive, it allows the user
to complete any transaction activity. As soon as the user issues either a commit or
roll back command the session is disconnected.
IMMEDIATE : This simply kills the session. It releases all allocated session
resources, sends the ORA-00028 error message to the user, and kills the Oracle
server process. The DISCONNECT IMMEDIATE option behaves the same as the
KILL IMMEDIATE option.
In the above image it can be seen there is a blocking session ( A ) whose SID is 159 ,
according to V$SESSION this is blocking three other sessions, 138 , 153 , and 130 .
The DBA issues a simple KILL SESSION command ( B ), this kills the user session,
but as there are no parameters specified to kill the session, the default behavior
of this command will simply kill the session, the entry at the V$SESSION will
remain there until somehow the oracle server detects some user activity so it can
send the ORA-00028 error message. When monitoring the sessions, the KILLED
status ( C ), as well as the new blocking session, session 138 ( D ), which was the next
session in line on the enqueue mechanism, all killed sessions are reported in the
alert <SID>.log file.
 
Search WWH ::




Custom Search