JDBC driver parameters

From: Jean Berthold <jean.berthold_at_eos-gd.ch>
Date: Fri, 21 Feb 2003 06:19:14 -0800
Message-ID: <F001.00554345.20030221061914@fatcity.com>

Hello,

We have an Java application wich is establish a database connection via JDBC driver,
by using a parameter file:

---

#JDBC_Driver=oracle.jdbc.driver.OracleDriver
#JDBC_URL=jdbc:oracle:thin:@chicago.eos.elro:1521:dgesten
#JDBC_User=...
#JDBC_Password=...

---

Sometime the connection time is very long. In the same time, if I try to connect via SQLPLUS, the connection is immediate ...

Questions:

---

1. Is it possible to give SDU and TDU parameters on the JDBC connect string ? (tnsname isn't used by JDBC, true ?) I have SDU=32767 and TDU=32767 in my tnsnames.ora. It is quick, but it is a correct setting ?
2. Are response time given by wait_event view, like event="SQL*Net..." including JDBC connections ?
3. Is a big value in the event field time_waited (for SQL*Net ...) necessarily mention a network problem, or a bad parameter connection ?

About wait_events, what do you think about this statspack ouptut ?

                                                                    Avg
                                                     Total Wait    wait
Waits
Event                               Waits   Timeouts  Time (cs)

(ms) /txn

---------------------------- ------------ ---------- ----------- ------

---

...
...
SQL*Net break/reset to clien 2 0 0 0 0.0
SQL*Net message from client 51,171 0 6,502,293 1271 40.5
SQL*Net more data from clien 81 0 14 2 0.1
SQL*Net message to client 51,171 0 9 0 40.5

Thanks for your help, have a nice week-end and ... I hope you will understand my english wich is so ugly :-(

Jean

--
________________________________

Jean Berthold
EOS - energie ouest suisse
Chemin de Mornex 10 , CP 570
CH-1001 Lausanne , Switzerland
Tel. : +41 (0)21 341 24 58
Fax  : +41 (0)21 341 20 49
E-Mail : jean.berthold_at_eos-gd.ch
________________________________


  ...Unix is like a wigwam - no windows, no gates, apache inside...



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jean Berthold
  INET: jean.berthold_at_eos-gd.ch

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Feb 21 2003 - 08:19:14 CST