Getting shared pool error messages
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Getting shared pool error messages

  1. #1
    Join Date
    Feb 2002
    Posts
    21

    Exclamation

    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Feb 2001
    Posts
    290
    You may wish to read this metalink documnet too

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

    Thanks,
    Madhu

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  5. #5
    Join Date
    Feb 2002
    Posts
    21
    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.

  6. #6
    Join Date
    Feb 2002
    Posts
    21

    Patch question??

    Any ideas?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width