BAMIMA Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: BAMIMA Error

  1. #1
    Join Date
    Sep 2000
    Location
    Calcutta / Ahmedabad, India
    Posts
    137

    BAMIMA Error

    Hi,

    I am getting this error. Can anyone help me identify the reason.
    --------------------------------------------------------------------
    ORA-04031: unable to allocate 4048 bytes of shared memory ("shared
    pool","unknown object","sga heap","state objects")

    The free memory gets reduced from 800M to 40M

    BAMIMA error
    -----------------------------------------------------------------

    Thanks
    Suvashish

  2. #2
    Join Date
    Feb 2002
    Posts
    70
    Qoute from Oracle TECH Doc

    Cause: More shared memory is needed than was allocated in the shared pool.
    Action: If the shared pool is out of memory, either use the
    DBMS_SHARED_POOL package to pin large packages, reduce your use of
    shared memory, or increase the amount of available shared memory by
    increasing the value of the initialization parameters
    SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE. If the large
    pool is out of memory, increase the initialization parameter
    LARGE_POOL_SIZE.

    Thanks,
    ________________
    ShanDJ

  3. #3
    Join Date
    Sep 2000
    Location
    Calcutta / Ahmedabad, India
    Posts
    137
    Thanks, but memory leak is taking place i guess. I think i have hit a bug. I am running 8.1.6.3.1.0 . Metalink says to apply patch 4 for version 8.1.7. Can anyone give me any solution for 8.1.6.3.1.0


    Thanks
    Suvashish

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    Identify the large PL/SQL modules and pin them in memory.

  5. #5
    Join Date
    May 2002
    Posts
    2,645
    BAMIMA error? Okay, I'm stumped. What does BAMIMA stand for?

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