| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_credit-suisse.com
www.credit-suisse.com
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 30 2007 - 15:56:21 CST
 |
 |