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 -> Space shortage in SGA

Space shortage in SGA

From: mpinzuti <mpinzuti_at_virgilio.it>
Date: Tue, 30 Oct 2001 09:42:01 +0000 (UTC)
Message-ID: <3BDE39BA000003CE@ims2a.cp.tin.it> 





I launched a PL/SQL script made of about 3500 rows and after a while the
DBMS prompted this:


ORA-04031: unable to allocate 39296 bytes of shared memory ("unknown
object","PL/SQL MPCODE","BAMIMA: Bam Buffer")
I don't know whether Oracle has got a limited number of rows in a script
to carry out but how can I solve my problem?



Thanks in advance!!






-- 
Posted from vsmtp3.tin.it [212.216.176.223] 
via Mailgate.ORG Server - http://www.Mailgate.ORG


Received on Tue Oct 30 2001 - 03:42:01 CST












Original text of this message













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