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 : [EMAIL PROTECTED]
________________________________
...Unix is like a wigwam - no windows, no gates, apache inside...
