Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle... one DB connects, one does not...

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

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Wed, 19 Jul 2006 22:34:13 -0600
Message-ID: <KEEDIPJOJLCHPPAIDPDOCEMPCEAA.robertgfreeman@yahoo.com>


I know I checked waits early on and even ran a 10046 trace. It's been like 2 weeks ago or more now. We will be doing some testing tomorrow and I'll look again. The 10046 trace file for the statement in question shows the EXEC, several waits on SQL*Net message to client and SQL*Net message from client and SQL*Net more data to client. There is also a db file scattered read wait.... but NONE of these waits amounts to much clock time at all (the longest is an elapsed of 6953 on the db file scattered read).

We then get the fetch, with an e=169353, and then the trace simply stops. I think it's at this point that something is not right with the driver or the data or something. The question is, what and why...

RF

-----Original Message-----
From: Jeremiah Wilton [mailto:jeremiah_at_ora-600.net] Sent: Wednesday, July 19, 2006 8:53 PM
To: 'Robert Freeman'
Cc: oracle-l_at_freelists.org
Subject: RE: Oracle... one DB connects, one does not...

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 - 23:34:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US