Performance issue in multi-level Oracle Object/thin JDBC Options Options

Discussion in 'Java' started by jacksu, Oct 9, 2007.

  1. jacksu

    jacksu Guest

    Hi All,

    We are trying to call Oracle 9i Stored Procedure with ThinJDBC, the
    parameter in Stored procedure is multilevel object:


    Table of Object1
    +------- Object1
    +------ Table of Object2
    +------ Object2
    +----- attribute in
    simple oracle types, such as varchar.


    The query for that call is very light way, just get two records from
    a
    hundred records table. But the whole execution time is around 600ms
    to
    1000ms.


    If we change to one level Oracle Object


    +---- Object
    +------- attributes


    with the same query data, the execution time is around 100 ms.


    I am wondering where to start to troubleshoot the performance
    problem,
    500 ms is not acceptable in the production environment.

    We checked the stored proc elapse time, very minimum, less than 10 ms.
    So seems most of the time is in JDBC side. Any suggestion to
    troubleshoot JDBC performance issue?


    Thanks in advance.
     
    jacksu, Oct 9, 2007
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Cookie Monster

    writing clobs using oracle thin driver

    Cookie Monster, Nov 11, 2004, in forum: Java
    Replies:
    2
    Views:
    2,722
    steve
    Nov 13, 2004
  2. Betty
    Replies:
    1
    Views:
    10,100
    Malte
    Apr 22, 2005
  3. Betty
    Replies:
    1
    Views:
    9,928
    Juha Laiho
    May 21, 2005
  4. Ramji
    Replies:
    3
    Views:
    2,917
    Bjorn Abelli
    May 4, 2006
  5. pabbu
    Replies:
    8
    Views:
    768
    Marc Boyer
    Nov 7, 2005
Loading...

Share This Page