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

Thread: To Much Memory??

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    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
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    18 MB for SP is too low. You have to increase it to higher size.
    Also, consider increasing db_block_buffers.

    Tamil

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