Periodically experience ORA-04031
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Periodically experience ORA-04031

  1. #1
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257

    Periodically experience ORA-04031

    DBAs,

    We have 3 old databases, which stay at 8.1.7.0. Due to some reason, we cannot upgrade them

    There is a pattern which after running for 2 or 3 months, we experience a lot of ORA-04031: unable to allocate 4096 bytes of shared memory.

    Even flushing the shard pool is no use.
    Our current practice is just restarting the database.
    But is there other good way to help solve this problem instead of database restart.

    Thanks,

    Lily

  2. #2
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by Lily_Liu_2004
    DBAs,

    There is a pattern which after running for 2 or 3 months, we experience a lot of ORA-04031: unable to allocate 4096 bytes of shared memory.

    Even flushing the shard pool is no use.
    Increase the SHARED_ POOL_SIZE and SHARED_ POOL_RESERVED_SIZE. Stop bouncing the database.

    If you dont have much physical memory reduce your use of shared memory.
    "What is past is PROLOGUE"

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    increasing wont help, will just put it off and maybe give you more errors / performance problems

    fix the application and make it use bind variables

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