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

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.

.

Relevant Pages

  • Re: Performance issue in multi-level Oracle Object/thin JDBC
    ... parameter in Stored procedure is multilevel object: ... simple oracle types, such as varchar. ... found out that the stored proc execution time is under 10 ms. ... precisely, the java code), but you have a stack of interacting ...
    (comp.databases.oracle.server)
  • Performance issue in multi-level Oracle Object/thin JDBC Options Options
    ... We are trying to call Oracle 9i Stored Procedure with ThinJDBC, ... the execution time is around 100 ms. ... troubleshoot JDBC performance issue? ...
    (comp.lang.java.programmer)
  • Re: Error in calling stored procedure via DB link
    ... "Paul Clement" wrote: ... Below is an Oracle KB article that documents the issue. ... Calling Stored Procedure over Dblink Using Oracle OleDb Provider Fails ... > symptom: Using command type adCmdStoredProc ...
    (microsoft.public.vb.database.ado)
  • Re: Performance problems with StoredProcedure in Web application
    ... you could probably just ignore my comments about stored procedure performance as compared to textual queries because they ... As for your question about how to avoid using a cursor (as I suggested was possible in Oracle) read the following paragraph for more ... The .NET Framework Data Provider for Oracle does not support batched SQL statements. ... CURSOR output parameters to fill a DataSet, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Passing Back Table Information from Oracle .NET Stored Procedures
    ... stored procedure, not in the typical PL/SQL sense. ... I don't care if it's MS SQL in-line code or Oracle in-line code, MS SQL Server, Oracle Proc, or this so called .NET Stored Procedure using a Select statement, they are all returning a RESULT SET whether it be one row or multiple rows. ... I used SqlContext above because I don't want to bother registering at the Oracle site to download their Oracle Database Extensions for .NET in order to get at the presumably extant OracleContext class. ...
    (microsoft.public.dotnet.languages.csharp)
Quantcast