Re: ORA-00031

This is what I get from a query of one of my hung sessions: The only difference with a session which is running properly is: state, seconds in wait and wait_time.

SQL> select * from v$session_wait where sid = 39;

  39 32897 SQL*Net message from client driver id
675562835 28444553
#bytes
1 00000001

0 00              -2
          17652 WAITED UNKNOWN TIME

--
Julio César Glez Suarez
Xixón, Asturies, Spain
jgonzalezsuareNO_at_SPAMnexo.es (Remove NO SPAM)