Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-00031
A windows95 pc hangs while executing forms.
Then, his session remains active forever.
I query v$sqltext to see whats being done by this session, and it's
doing only any simple select statement.
I olso query the v$lock to check that there is no locking involved
with this session.
I alter system kill session, and I receive this error:
ORA-00031 Session marked for kill, which means that the session is
involved in a non-interruptible operation.
I've waited during days, but this session will not die.
How can I find out what kind of "non-interruptible operation" is this session involved in?
Thanks.
-- Julio César Glez Suarez Xixón, Asturies, Spain jgonzalezsuareNO_at_SPAMnexo.es (Remove NO SPAM)Received on Fri Jun 02 2000 - 00:00:00 CDT