Re: ORA-04031 shared memory

Hello,

1. Pls. run statspack (10-15 min interval) and post its output.
2. Run this simple query and check if you are indeed using binds:

select count(decode(executions, 1, 1)) one_time, count(decode(executions, 1, null, 1)) more_than_one from v$sql;

3. PL/SQL may be using dynamic queries (execute immediate).

VC

"Lars" <lrebyc_at_yahoo.de> wrote in message news:4f1480e2.0404052349.2b4db5c0_at_posting.google.com...
> >
> > Typical case of shared pool fragmentation. The requested 4200 bytes
> > are available, but not contiguously.
> > There is a note up on Metalink with a query to determine whether
>,
>
> Lars
Received on Tue Apr 06 2004 - 07:16:50 CDT