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.