Home » Developer & Programmer » JDeveloper, Java & XML » Pin Java Stored Procedure in Memory
Pin Java Stored Procedure in Memory [message #222840] Tue, 06 March 2007 11:15
Messages: 50
Registered: December 2005
I have a PL/SQL packaged procedure that calls a small java stored procedure (about 20 lines) to dump a file from the database to the operating system via a web based form. The first time the procedure is run it takes 20 to 30 seconds to complete. Subsequent runs take about 1 second. It looks like the time is used in the java stored procedure. Since subsequent run performance is fine, I'm guessing that the java program is getting loaded into memory or something on the 1st execution.

Does this make sense? Is there a way to "pin" a java stored procedure into memory?

Thanks in advance for any suggestions...
Previous Topic: ORA-29532: Java call terminated
Next Topic: How to open an Oracle Report from a JSF Page
Goto Forum:

Current Time: Tue Aug 22 06:12:14 CDT 2017

Total time taken to generate the page: 0.01792 seconds