ORA-00031

Error: ORA-00031: session marked for kill

Causa: 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.

Acción: 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.

COMENTARIOS:

por Anónimo | 12/09/2006 17:24:27

RE: ORA-00031

POSIBLEMENTE ESTE ERROR TE DE CUANDO HAGAS UNA OPERACION MUY LARGA O EL BORRADO DE UNA TABLA MUY GRANDE O LA INSERCION DE MUCHOS REGISTROS POR BARRIDO
SOLO DEJA QUE EL SISTEMA MATE LA SESSION CUANDO TERMINE EL ROLLBACK