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. Advertisements

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.