Search notes:

Oracle: Init parameter PARALLEL_THREADS_PER_CPU

The value of parallel_threads_per_cpu should be incresed in systems where the I/O subystem is too slow and essentially leaves the CPUs in an idle state for most of the time.
The default value changed from 2 before Release 12.2 to 1 in Release 18.
The value of parallel_threads_per_cpu influences the default value of other parallel execution parameters such as parallel_max_servers.

See also

Other init parameters such as cpu_count
MOS Note 399086.1

Index