While working to get my Oracle database upgraded to a supported version, using the DBUA I was getting the following errors:<\/p>\n
ORA-04031: unable to allocate 704 bytes of shared memory \r\n(\"shared pool\",\"unknown object\",\"PX subheap\",\"qref (kxfpqr)\")<\/pre>\nor in a different upgrade<\/p>\n
ORA-04031: unable to allocate 40 bytes of shared memory \r\n(\"shared pool\",\"SELECT DECODE(null,'','Total...\",\"SQLA\",\"tmp\")<\/pre>\nUnable to find anything helpful in “My Oracle Support” (Metalink) or in a Google search, I opened a ticket with Oracle support.\u00a0 After two weeks and uploading many log & trace files,\u00a0 Oracle support final got someone who came back with the following recommendation:<\/p>\n
<\/p>\n
To resolve this;<\/em><\/p>\n
1) set the sga_target to a large value and this will fix the issue<\/em><\/p>\n
OR<\/em><\/p>\n
2) Reduce the PARALLEL_MAX_SERVERS and CPU_COUNT to a lower value<\/em><\/p>\n
<\/p>\n
The SGA_TARGET was set larger then many databases that I have already successfully upgraded.<\/p>\n
However, my PARALLEL_MAX_SERVERS was set to 1,200.\u00a0 When I reduced that to 200, the upgrade completed successfully.\u00a0\u00a0 Also on the “Upgrade Options” tab, I left the “Select Upgrade Parallelism” at the default of 4.\u00a0 Before adjusting the PARALLEL_MAX_SERVERS parameter, the higher I set the Upgrade Parallelism, the faster I filled up the shared pool.<\/p>\n","protected":false},"excerpt":{"rendered":"