Java and JavaScript in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Poor Performance when using Oracle JVM

438381Jan 17 2007 — edited Aug 6 2007

Hello:

I have a basic 'SFTP' client implemented using the JSch classes provided by JCraft (http://www.jcraft.com/jsch/index.html). This SFTP client when run on the JVM on my workstation takes about 20 seconds to transfer a 25MB file over to my workstation from a remote server.
I installed the Jsch classes and the 'SFTP' client into an Oracle db (10.2.0) running on Windows XP Pro. I created a PL/SQL function wrapper for the SFTP client. Now, when I invoke this PL/SQL function from SqlPlus to initiate the transfer of the same file the total time takes is almost 8 minutes !
Any idea what would explain this huge difference in the transger time ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 3 2007

Added on Jan 17 2007

7 comments

3,618 views