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
rigatonip
Messages: 50
Registered: December 2005
Member
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: Wed Dec 07 16:13:32 CST 2016

Total time taken to generate the page: 0.13984 seconds