DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2001

    To Much Memory??

    I have a development database on a development server. We have a process that usually runs about 3 hours that we kicked off Friday and it blew up with the following error.

    ORA-20014: ORA-20002: Error occured in pkg_arl_month_end.p_create_index when creating indexes for
    ARL_9000_FLAG. ORA-12801: error signaled in parallel query server P000
    ORA-04031: unable to allocate 4180 bytes of shared memory ("shared pool","unknown object","sga
    heap","state objects")

    Before the process I had set the parameters as following

    db_block_buffers = 16000
    shared_pool_size = 18000000

    I figured I would make the memory larger so it would not blow up. As you can see it did. Would this error appear if the server ran out of memory? ow do you determine the memory availbe on a Unix AIX server? Is it possible I made the memory to big?

  2. #2
    Join Date
    May 2000
    18 MB for SP is too low. You have to increase it to higher size.
    Also, consider increasing db_block_buffers.


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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.