Re: ORA-00031

Query from v$session_wait:

SQL> desc v$session_wait

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 SID                                                NUMBER
 SEQ#                                               NUMBER
 EVENT                                              VARCHAR2(64)
 P1TEXT                                             VARCHAR2(64)
 P1                                                 NUMBER
 P1RAW                                              RAW(4)
 P2TEXT                                             VARCHAR2(64)
 P2                                                 NUMBER
 P2RAW                                              RAW(4)
 P3TEXT                                             VARCHAR2(64)
 P3                                                 NUMBER
 P3RAW                                              RAW(4)
 WAIT_TIME                                          NUMBER
 SECONDS_IN_WAIT                                    NUMBER
 STATE                                              VARCHAR2(19)

The following SQL statement displays all Oracle events:

SELECT *
FROM V$EVENT_NAME; Martin

"Lío" wrote:
>
> 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