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.


Thank you in advance.