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_at_cosmiccooler.org]
> Sent: Monday, October 04, 2004 5:10 PM
> To: oracle-l_at_freelists.org
> 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.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 04 2004 - 16:22:32 CDT
