Multiple execution for a table import

From: Js <jagjeet_malhi_at_hotmail.com>
Date: 24 Nov 2005 08:34:02 -0800
Message-ID: <1132850042.441525.199970@f14g2000cwb.googlegroups.com>

Hi,

I have traced my import session and found this...

---

INSERT /*+NESTED_TABLE_SET_REFS+*/ INTO "T" ("TABLE_NAME", "COMMENTS") VALUES
 (:1, :2)

call count cpu elapsed disk query current

    rows
------- ------ -------- ---------- ---------- ---------- ----------

---

Parse        1      0.00       0.01          0          1          0
       0
Execute  11228      8.85       9.81         71       2049     105158
   78592
Fetch        0      0.00       0.00          0          0          0
       0

------- ------ -------- ---------- ---------- ---------- ----------

---

total 11229 8.85 9.82 71 2050 105158

   78592

---

I have not used commit=y parameter then why there are multiple executions for this single command.

Thanks
Js Received on Thu Nov 24 2005 - 10:34:02 CST