| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Java stored procedures suddenly slow
This is solved. As part of a completely separate project, I had installed
Services for Unix to test accessing an NFS share from Windows. I haven't
dug into it far enough to determine why yet, but it killed the performance
of initial java loading. Uninstalling SFU resolved the issue.
On 1/23/07 9:21 PM, Jason Heinrich 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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 24 2007 - 10:48:15 CST
 |
 |