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

  • From: "Jeremiah Wilton" <jeremiah@xxxxxxxxxxx>
  • To: "'Robert Freeman'" <robertgfreeman@xxxxxxxxx>
  • Date: Wed, 19 Jul 2006 19:52:55 -0700

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@xxxxxxxxx] 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....


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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2006