Parameters during upgrade R12.1.3 and database 11.1.0.7

Posted by satish on Nov 08, 2022; 8:35am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Parameters-during-upgrade-R12-1-3-and-database-11-1-0-7-tp11211.html

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