You can check if you get two (or more) child cursors for your SQL query (and use v$sql_shared_cursor to see why). On Wed, Feb 4, 2015 at 1:45 PM, Ls Cheng <exriscer@xxxxxxxxx> wrote: > hmm > > I didnt flush the shared pool. > > What I did was > >