getting connection is very slow from oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: getting connection is very slow from oracle

  1. #1
    Join Date
    Aug 2005
    Posts
    2

    getting connection is very slow from oracle

    Hi everybody,
    could someone help me?
    i have two similar oracle 9i databases with similar parameter setting and same data.one is on a Proliant server and the other is on a normal pc.I wrote a java program that executes near 800 queries on both databases.when i use a single connection for executing all queries in my program, the proliant responses about 4 times faster but when i make a connection per each query, the pc is two times faster.I think my oracle on the pc makes the connection faster than the proliant. How can i improve time to getting connection from oracle on the proliant?
    Thanks.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    put tracing on in the client - see what you are waiting on

  3. #3
    Join Date
    Aug 2005
    Posts
    2
    how can i put tracing on in my jdbc client?

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    If you are using jdbc 3.0 from sun then

    If you use the DriverManager facility to establish your database connection, you use the DriverManager.setLogWriter method to enable tracing of JDBC operations.

    If you use a DataSource object to get a connection, you use the DataSource.setLogWriter method to enable tracing.

    For pooled connections, you use the ConnectionPoolDataSource.setLogWriter method,

    and for connections that can participate in distributed transactions, you use the XADataSource.setLogWriter method

    what jdbc driver are you using

    regards
    Hrishy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width