Anonymous block from Java--performance

Follow-up to my earlier post about insert performance.  This is 9.2.0.6 64-bit 
on Solaris.

An application executes an anonymous block 259 times.  The block consists 
solely of insert statements.  Trace shows total execution time for the 259 
calls as about 90 seconds:

  However, cumulative elapsed time of the insert statements adds up to about 19 
seconds.  

The trace file shows a lot of 'SQL*Net more data from client' waits on the 
anonymous block cursors, but tkprof doesn't.  I suspect that replacing the 
block with a stored procedure will help, but I don't yet have hard evidence of 
where the 70 

Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@xxxxxxxxxxxxxxxxx
www.credit-suisse.com



==============================================================================
Please access the attached hyperlink for an important electronic communications 
disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================

--
http://www.freelists.org/webpage/oracle-l

Other related posts: