Oracle tuning
Date: 1996/08/09
Message-ID: <32101857.167E_at_sic.epfl.ch>#1/1
Hi,
I work with the jdbcKona/Oracle product (JDBC driver
for the Oracle OCI database library, http://www.weblogic.com ).
I've an Oracle tuning issue. The connection to the database is taking 8
seconds and the select for determining your character set is 8 seconds!!
java login
DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
registerDriver:
driver[className=weblogic.jdbc.oci.Driver,context=null,weblogic.jdbc.oci.Driver_at_af3948]
DriverManager.getConnection("jdbc:weblogic:oracle") trying driver[className=weblogic.jdbc.oci.Driver,context=null,weblogic.jdbc.oci.Driver_at_af3948]
weblogic.jdbc.oci.Driver checking: jdbc:weblogic:oracle
Loading library:weblogicoci15
Finished loading library at:174
Connecting to database using: scott/tiger at 216
??????Connected to database at: 8842 ???????????
Parsing: SELECT LENGTHB('a') FROM DUAL
Executing: SELECT LENGTHB('a') FROM DUAL
??????Done logging in at: 16002 ???????????
Oracle version 7.3.2
The command "sqlplus scott/tiger" take ~1 second
The platform is : Silicon Graphics/IRIX6.2
Any suggestions to how I could solve this? Thanks in advance.
Francis Lapique
E-mail : lapique_at_sic.epfl.ch
Received on Fri Aug 09 1996 - 00:00:00 CEST