Slow Java stored procedure
From: Gabriel Radu <gabriel.radu_at_znt.de>
Date: 8 Nov 2001 08:36:09 -0800
Message-ID: <d9d350a7.0111080836.32562623_at_posting.google.com>
Date: 8 Nov 2001 08:36:09 -0800
Message-ID: <d9d350a7.0111080836.32562623_at_posting.google.com>
I have a Java stored procedure on Oracle 8.1.6 , that doesn't fetch rows from database(it performs only mathematical calculations). Running the procedure localy as a normal Java class , it takes 2 seconds but as stored procedure it takes about 1 minute. The java_pool_size is large enough(50 M). What could be the reason for such a big difference ? Thank you! Received on Thu Nov 08 2001 - 17:36:09 CET