Session Status
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Session Status

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    Hi,

    I had killed 2 sessions about 3 days back. But Still I am able to see those sessions in v$session view where as the status appears to be as "Killed".

    When will the session record get out of the v$session. How can I eliminate this 'Killed' record
    Badrinath

  2. #2
    Join Date
    Jul 2000
    Posts
    243
    Hi badrinathn

    when looking at the orace documentation chapter 4, Managing Oracle Processes, in administration guide (page 106-107) it is writen better then i can write it, so i simply copyd the following part's:

    If a user session is making an SQL call to Oracle (is ACTIVE) when it is terminated,
    the transaction is rolled back and the user immediately receives the following mes-sage:
    ORA-00028: your session has been killed
    If an active session cannot be interrupted (for example, it is performing network I/
    O or rolling back a transaction), the session cannot be terminated until the opera-tion
    completes. In this case, the session holds all resources until it is terminated.
    Additionally, the session that issues the ALTER SYSTEM statement to terminate a
    session waits up to 60 seconds for the session to be terminated; if the operation that
    cannot be interrupted continues past one minute, the issuer of the ALTER SYSTEM
    statement receives a message indicating that the session has been “marked” to be
    terminated. A session marked to be terminated is indicated in V$SESSION with a
    status of “KILLED” and a server that is something other than “PSEUDO.”


    If the session is not making an SQL call to Oracle (is INACTIVE) when it is termi-nated,
    the ORA-00028 message is not returned immediately. The message is not
    returned until the user subsequently attempts to use the terminated session.
    When an inactive session has been terminated, STATUS in the view V$SESSION is
    “KILLED.” The row for the terminated session is removed from V$SESSION after
    the user attempts to use the session again and receives the ORA-00028 message.

    hpe this help

    p.s.


  3. #3
    Join Date
    Jan 2001
    Posts
    642
    That was fine, however the problem is to remove these 'KILLED' sessions physically from v$session.
    The corresponding process neither exist in v$process nor on the operating system (ps -ef).

    What do I do to remove this record from v$session;
    badrinath

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width