Re: Java stored procedures suddenly slow
- From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- To: jheinrich@xxxxxxxx
- Date: Wed, 24 Jan 2007 11:21:02 +0100
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@xxxxxxxx> 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@xxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
