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
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?
18 MB for SP is too low. You have to increase it to higher size.
Also, consider increasing db_block_buffers.
Click Here to Expand Forum to Full Width