RE: Oracle... one DB connects, one does not...

From: Jeremiah Wilton <jeremiah_at_ora-600.net>
Date: Wed, 19 Jul 2006 19:52:55 -0700
Message-ID: <011901c6aba7$9a54ba90$6c01a8c0@flbp7000a>

Robert,

When you look at v$session_wait for one of the JDBC sessions that is hanging, what are the values of EVENT and SECONDS_IN_WAIT? Also is SEQUENCE# incrementing?

That will help narrow it down to either the database or NOT the database.

--
Jeremiah Wilton
ORA-600 Consulting
http://www.ora-600.net

Robert Freeman [mailto:robertgfreeman_at_yahoo.com] wrote:



> Well.... thats kind of the problem, we are not sure. We know the SQL that 

> is getting executed, and we can run it fine from SQL*Plus. The JDBC 

> connection is made, and about 3 queries are successful and then the one 

> that we have identified as problematic just seems to hang. We sent JDBC 

> traces to Oracle, database traces, we have had the vendor here,

> etc...etc.... and nobody seems to have any idea what is causing this 

> problem or exactly WHAT we are hanging on....



--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 19 2006 - 21:52:55 CDT