KILL Sessions on NT - Error 00031
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: KILL Sessions on NT - Error 00031

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Trying to kill a session thus:

    alter system kill session '17,3895'
    *
    ERROR at line 1:
    ORA-00031: session marked for kill

    And V$SESSION still shows the session. Whats happening?

  2. #2
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    OK ...

    ORA-00031 session marked for kill

    Cause: The session specified in an ALTER SYSTEM KILL SESSION command cannot be killed immediately because the session is involved in a non-interruptible operation (for example, rolling back a transaction or being blocked by a network operation). The session has been marked to be killed as soon as possible after the current operation is done.

    Action: No action is required for the session to be killed, but further executions of the ALTER SYSTEM KILL SESSION command on this session may cause the session to be killed sooner

    So - question is ... How do I discover what the non-interruptible operation is? The session was an application session that's a day old. I don't know the app so I can't guess what it might be doing?

  3. #3
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    joining v$session & v$sqlarea shows the session to be issuing a SELECT * from a view. So ... its not likely to be locked by a ROLLBACK is it?

    Any ideas anyone?

  4. #4
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    another way to kill as session

    Read note 69882.1 on metalink

    HTH
    Gert

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