Vijay what u said is correct, but in the V$SESSION Table , STATUS of user should not be KILLED, till the process is completed, atleat it should be INACTIVE. Am i correct?
Originally posted by oravijay
Hi,

If the session, has submitted a job and Oracle is Processing a request submitted by the
client process then it cannot kill that session immediately. So, it marks the session as
Killed and as-soon-as the processing is over, it removes the information about the
user from V$SESSION view. Until, the record is removed, it means that Oracle has not
killed the users' session completely.

Vijay.