Parameters during upgrade R12.1.3 and database 11.1.0.7

[satish]

Dear erman


We have 32GB RAM

Toraprod@SSSTINDCPODB02 ~1$ cat /proc/ cpuinfo grep -i processor wc -I
24

[oraprod@SSSTINDCPODB02 ~]$

[oraprod@SSSTINDCPODB02 ~]$ cat /proc/ cpuinfolgrep -i processor processor
:0
processor
: 1
processor
:2
processor
:3
processor
:4
processor
: 5
processor
: 6
processor
: 7
processor
:8
processor
: 9
processor
:10
processor
: 11
processor
: 12
processor
:13
processor
:14
processor
:15
processor
:16
processor
:17
processor
:18
processor
:19
processor
: 20
processor
:21
processor
:22
processor
:23


Before the upgrade, what are the values that we set for good performance of upgrade without getting stuck with too many parallel process.

job_queue_processes
parallel_max_servers
cpu _count

Our parallel_threads_per cpu-->2

Thanks,
Satish

[ErmanArslansOracleBlog]

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.