Re: Memory issues

In article <koYV5.631$HO4.102494_at_nntp3.onemain.com>,   "Barbara Kennedy" <barbken_at_teleport.com> wrote:
> Sounds like you are out of shared pool, but we would need the exact
 error to
> know.
> Jim

Yes, you are right. Here is a sample error. The number of bytes listed varies, but the rest is the same each time:

ORA-04031: unable to allocate 4224 bytes of shared memory ("shared pool","SELECT X.spot_id, X.intensit...","sga heap","library cache")

> "gene" <gene01_at_smalltime.com> wrote in message
> news:gene01-ACF41B.09064701122000_at_news.concentric.net...
> > I'm getting errors from Oracle about running out of memory
> > (Can't allocate 512 bytes for ....). I don't have the
> > exact text of the error and of my query with me right now,
> > so this will be a little general.
> >

 ...
> >
> > Because this happens only after multiple queries, it is as
> > if there is a memory leak, or as if oracle is saving all
> > the previous queries or something.
> >
> > My current plans are to try this a stored procedure with
> > bind variables. But does anyone have any ideas about why
> > this would be happening? Is there something I can flush
> > to fix this? My dba has been allocating more memory for
> > me, but that hasn't helped.
> >

.
.
.
.
.
.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 04 2000 - 14:10:14 CST