hi Antony, from the trace, do you see any recursive sql take up long time? On Wed, Feb 8, 2012 at 1:08 AM, Iotzov, Iordan <IIotzov@xxxxxxxxxxxxxxx>wrote: > Are there any triggers or constraints defined on the table? > > -- Regards Sidney Chen -- //www.freelists.org/webpage/oracle-l