Insufficient shared pool. If there are other SQL statements besides the ones executed by users, then you may have problems with recursive statements. I seem to recall a table called V$ROWCACHE. Also, there is a table called V$SQLAREA which has a column named "PARSE_CALLS". When Jared advised you to investigate, digging into those tables is probably what he had in minds. Also, taking a peek into V$SYSTEM_EVENT should not be misunderestimated. -- Mladen Gogala A & E TV Network Ext. 1216 > -----Original Message----- > From: David [mailto:thump@xxxxxxxxxxxxxxxx] > Sent: Monday, October 04, 2004 5:10 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: Re: parse > > > > > What could cause such a thing? > > -- > > .. > > David > > > >> Kind of interesting that your parse misses (failures) is > >> 8 time higher than total parse count. > > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l