Re: Parameters during upgrade R12.1.3 and database 11.1.0.7

Posted by ErmanArslansOracleBlog on Nov 08, 2022; 4:46pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Parameters-during-upgrade-R12-1-3-and-database-11-1-0-7-tp11211p11213.html

There are no magic numbers for these settings.  Generally no additional care needed for the upgrade. They just should be in their optimized settings before the upgrade.
Here is what I can say;

Leave cpu_count to Oracle.
For parallel max servers see -> New Default Value of PARALLEL_MAX_SERVERS in Release 11.2.0.2 (Doc ID 1377411.1)
job_queue_processes is not super directly related with the CPU count. Set it to non-zero value, to 12 for instance.