Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-04031 shared memory

Re: ORA-04031 shared memory

From: VC <boston103_at_hotmail.com>
Date: Tue, 06 Apr 2004 12:16:50 GMT
Message-ID: <Scxcc.196566$_w.1917461@attbi_s53>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US