Pages

Wednesday, April 5, 2017

How does adpatch determine the number of workers to recommend

How does adpatch determine the number of workers to recommend


The calculation is based on specific values returned from V$PROCESS and V$PARAMETER.

- the number of user processes
- CPUs available for the instance
- init.ora parameter for maximum parallel query processes
- total number of existing processes that are running

message(example):
==================
AD utilities can support a maximum of 999 workers. Your current database
configuration supports a maximum of 124 workers. Oracle recommends that you use
between 16 and 32 workers.

==================
- 999 is a predefined constant.
- 124 = (the number of user processes),(init.ora parameter for maximum parallel query processes)
and (total number of existing processes that are running).

16 workers = (2 * cpu_count) and 32 workeres = (4 * cpu_count)

The number of workers supported by same machine can change from one session to the next one and is influenced by the number of process currently running.


Reference metalink Doc ID 800024.1

No comments:

Post a Comment