RE: parse

  • From: "Gogala, Mladen" <Mladen.Gogala@xxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 4 Oct 2004 17:26:56 -0400

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

Other related posts: