RE: ORA-04031 on Oracle 8.1.7.0
- From: Paula Stankus <paulastankus@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 28 Jun 2006 17:06:49 -0700 (PDT)
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:
- » RE: ORA-04031 on Oracle 8.1.7.0
