Re: Oracle 9i JDBC Performance When Calling A Stored Procedure

Hard to tell what's wrong, but I would guess poorly configured system and wait events out the wazoo.

I also found it interesting that some posts were from people that do not use Oracle and were critical of Oracle tools because they think in a Java box. Too bad for them (and their companies).

duffymo wrote:
> There's a thread at the Java JDBC forum where someone is experiencing
> slow performance when calling an Oracle stored procedure:
>
> http://forum.java.sun.com/thread.jsp?forum=48&thread=456117&start=0&range=15#2086679
>
> One poster wrote a terrific tester that gives timings for calling a
> simple stored proc. I've taken that code, run it on my machine, and
> gotten results that are 10X faster than the original poster running
> the same code.
>
> After reviewing that thread, would anyone have some ideas to explain
> the poor performance in the OP's code? Thanks - MOD

-- 
Ron Reidy
Oracle DBA