Re: Java stored procedures suddenly slow

From your question it seems you're executing an external procedure through java ? Some OS script you run through pl/sql -> java -> windows ?

I don't know much about windows, but perhaps, in your script you can place some timing calls in front and after the call to the zip command, to see where the time is spent ?

One other thing to look at, could be the listener log. For extproc calls, you should be using a separate listener. Perhaps the time is also lost when the listener forks/spawns the new process/thread to execute your program. For the second call, the process could already be there - and therefore execute much faster. Though, like mentioned before - I don't know enough about windows to be able to tell wether this is actually possible or not. But it might give you some hints on where else to look

Stefan

On 1/24/07, Jason Heinrich <jheinrich_at_pcci.edu> wrote:
>
> I had a puzzling issue pop up this morning. The first time a session
> executes a java stored procedure, it takes an extremely long time to
> return.
> Every execution thereafter, within the same session, would return very
> quickly. For example, I executed a procedure to zip a 1 MB text file, and
> it took 84.6 seconds. I ran it again and it only took 0.14 seconds.
>
> I can accept that something might take a little longer the first time it's
> executed, but I've never seen it perform this poorly. A trace shows that
> all of the time is spent executing. So far Google hasn't been much help.
> Any ideas?
>
> Windows Server 2003
> Oracle 10.2.0.2 Standard Edition
> JAccelerator is installed.
>
> ---------------
> Jason Heinrich
> Oracle Database Administrator
> Pensacola Christian College
> (850) 478-8496 x2509
> jheinrich_at_pcci.edu
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l