From: Lío <jgonzalezsuareNO@SPAMnexo.es>
Subject: Re: ORA-00031
Date: 2000/06/06
Message-ID: <odmqjsoujnogib9v6th4mpptosu527g23l@4ax.com>#1/1
Content-Transfer-Encoding: 8bit
References: <jfbfjskhe1fbi3dkjralv1qpgkmdfthejt@4ax.com>
Organization: Personal
Content-Type: text/plain; charset=ISO-8859-1
Mime-Version: 1.0
Newsgroups: comp.databases.oracle.server


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@SPAMnexo.es (Remove NO SPAM)