DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Ora-04031

  1. #1
    Join Date
    Aug 2002
    Location
    Bangalore
    Posts
    52

    Post Ora-04031

    Hi Guys,

    When I am trying to execute a PL/SQL script in my DB I am getting the following error


    ORA-04031-Unable to allocate 4096 bytes of shared memory ( "Shared pool" "BAMIMA Bam buffer" )


    I guess that there is not enough free memory in shared pool. we need to increase the shared_pool_size.What do u guys suggest?

    Oracle - 8.1.7
    OS -Sun Solaris

    Regards

    Joe

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    Hi

    Hi

    1. Restart your database and run the PL/SQL procedure

    or

    2. Run the statement " ALTER SYSTEM FLUSH SHARED_POOL;" and run the PL/SQL procedure

    If dosen't work after wards, it seems to be a bug. Please post the minor version of the database, ie 8.1.7.xxx.. The value of xxx?

    Thanks


    Thomas
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

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