RE: ORA-04031 on Oracle 8.1.7.0

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.

Other related posts: