-
Hi,
I'm running oracle 8.1.7 on linux suse 7.3. I've looked at my shared pool settings, sizes and invalidations etc.. I'm getting 99% gethits but my invalidations are very high but where currenlty doing alot of development changes to packages/forms...
What should I do when getting this often..... PLEASE HELP?
ERROR:
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","begin
dbms_output.disable; e...","PL/SQL MPCODE","BAMIMA: Bam Buffer")
Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","begin
DBMS_APPLICATION_INFO....","PL/SQL MPCODE","BAMIMA: Bam Buffer")
Thanks in advance
-
-
You may wish to read this metalink documnet too
http://metalink.oracle.com/metalink/...&p_id=146599.1
Thanks,
Madhu
-
since it's pl/sql code I would consider tune shared_pool_reserved_size parameter, may be by increasing it you could get rid of this problem
-
I've looked on metalink, am I downloading the correct patch...?
ID:950172 Patchset::1882450
8.1.7.2 PATCH SET FOR ORACLE DATA SERVER
Its 114mb??
Cheers
kev.
-
Patch question??
