Hi,

If u need to check the status of a session , query the status column in the V$session view. It will show "active" when the session is active or else it shows "killed" or "inactive".