Perhaps a problem with Bind Variables and adaptive cursor sharing? I have heard of tens of thousands if cursors in some scenarios. Neil. sent from my phone On 2 Nov 2010, at 05:30, Stalin <stalinsk@xxxxxxxxx> wrote: > Nope we have it set to EXACT. > > On Mon, Nov 1, 2010 at 9:42 PM, Michael Dinh <mdinh@xxxxxxxxx> wrote: >> What is your cursor_sharing set to? >> >> If it's SIMILIAR, then this might be the side effect. >> >> Michael Dinh : XIFIN : 858.436.2929 >> > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l