Getting shared pool error messages

[kevwidd]

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

[marist89]

http://www.dbasupport.com/forums/sho...threadid=21758
http://www.dbasupport.com/forums/sho...threadid=21681

[mrvajrala]

You may wish to read this metalink documnet too

http://metalink.oracle.com/metalink/...&p_id=146599.1

Thanks,
Madhu

[pando]

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

[kevwidd]

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.

[kevwidd]

Any ideas?