The MERITS Performance Optimization Method - Secrets of the Oracle Database - page 385

Figure 28-1. Top SQL Statements section of an Active Session History report
According to the ESQLTRCPROF report, 71 rows were inserted into the table IMAGES .
Hash Value: 3858514115 - Total Elapsed Time (excluding think time): 0.146s
INSERT INTO images (id, date_loaded, exif_make, exif_model, exif_create_date,
exif_iso, exif_f_number, exif_exposure_time, exif_35mm_focal_length, image_data)
VALUES(:id, sysdate, :exif_make, :exif_model,
to_date(:exif_create_date, 'yyyy:mm:dd hh24:mi:ss'),
:exif_iso, :exif_f_number, :exif_exposure_time, :exif_35mm_focal_length,
empty_blob())
DB Call Count Elapsed CPU Disk Query Current Rows
------- -------- ---------- ---------- -------- -------- -------- --------
PARSE 71 0.0026s 0.0156s 0 0 0 0
EXEC 71 0.1203s 0.0781s 1 71 495 71
FETCH 0 0.0000s 0.0000s 0 0 0 0
------- -------- ---------- ---------- -------- -------- -------- --------
Total 142 0.1229s 0.0938s 1 71 495 71
Since the interval covered by the trace file was 74.9 seconds, 56 LOBs were inserted per
minute. What struck me was that there were also 71 parse calls for this INSERT statement. This
was an indication that the parse call for the INSERT statement was done in a loop instead of just
once before entering the loop.