RE: ORA-04031 on Oracle 8.1.7.0

From: Paula Stankus <paulastankus_at_yahoo.com>
Date: Wed, 28 Jun 2006 17:06:49 -0700 (PDT)
Message-ID: <20060629000650.32782.qmail@web33207.mail.mud.yahoo.com>

Oracle Version 8.1.7.0
  Solaris 2.8    

  We ran into an issue using database links and mv's. It seemed to work to recreate instead of refreshing mv's but I am thinking that that might be causing an issue with the shared pool as now we are getting    

  ORA-04031: unable to allocate 17732 bytes of shared   memory ("shared pool","MV_AGE_GENDER","library cache","summary text")    

  MyDFSMV -
  ORA-04031: unable to allocate 4096 bytes of shared   memory ("shared pool","begin sys.dbms_snapshot_ut...","PL/SQL MPCODE","BAMIMA:   Bam Buffer")    

  I ran the following healthcheck finding a note on metalink    

  DOC>*                                                       *
DOC>* TITLE        : Shared Pool Estimation                 *
DOC>* CATEGORY     : Information, Utility                   *
DOC>* SUBJECT AREA : Shared Pool                            *
DOC>* DESCRIPTION  : Estimates shared pool utilization      *
DOC>*  based on current database usage. This should be      *
DOC>*  run during peak operation, after all stored          *
DOC>*  objects i.e. packages, views have been loaded.       *
DOC>* NOTE:  Modified to work with later versions 4/11/06   *
DOC>*                                                       *
DOC>********************************************************/

Obj mem: 32640933 bytes
Shared sql: 1236627 bytes
Cursors: 22875 bytes
Free memory: 13015852 bytes (12.41MB)
Shared pool utilization (total): 40680522 bytes (38.8MB) Shared pool allocation (actual): 52428800 bytes (50MB)
Percentage Utilized: 78%
  PL/SQL procedure successfully completed.    

  Anyone know of any issues with mv's and shared pool or the way they are working and if I should just increase the shared pool size - I am about to do that.                  

---

Do you Yahoo!?
 Everyone is raving about the all-new Yahoo! Mail Beta.
--

http://www.freelists.org/webpage/oracle-l Received on Wed Jun 28 2006 - 19:06:49 CDT