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
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?