link between ORA-04031 and jobs
Hi Guys,
I have got another good one... We all know most common reasons of getting ora-4031 and oracle says that using automatically memory management greatly reduces this error but last night I saw lots of ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","unknown object","sga heap(2,0)","kkj jobq wor") errors in alert log while we are using automatic memory management with memory_target set to 10g.
We run lots of overnight jobs every night which runs perfectly and never threw ora-4031 but last night I kicked off an additional script which kicked off 110k database jobs and by 7pm it has finished 100k jobs. Also at 7pm we run our first daily schedule job which takes couple of hours to finish and at 9pm we take daily backup.
I have got another good one... We all know most common reasons of getting ora-4031 and oracle says that using automatically memory management greatly reduces this error but last night I saw lots of ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","unknown object","sga heap(2,0)","kkj jobq wor") errors in alert log while we are using automatic memory management with memory_target set to 10g.
We run lots of overnight jobs every night which runs perfectly and never threw ora-4031 but last night I kicked off an additional script which kicked off 110k database jobs and by 7pm it has finished 100k jobs. Also at 7pm we run our first daily schedule job which takes couple of hours to finish and at 9pm we take daily backup.
0