how to force HR Security List maintenance to run in several parallel threads
Hello gurus,
after migration to 12c database HR Security List maintenance execution time was drammatically increased up to twice and even triple..
We have found related notes: 222420.1, 394083.1, 226987.1(HRMS_and_BEN_11i_and_R12_Tuning_and_Health_Check.pdf) which states that due to MSL_PERSON_LIST is PYUGEN process, it can be managed by threads parameter of the PAY_ACTION_PARAMETERS, E18727_01/doc.121/e13509/T2096T2098.htm
We have tested the PAY_ACTION_PARAMETERS THREADS related to PERSLM + MSL_PERSON_LIST processes on the TEST environment.
New PAY_ACTION_PARAMETER_GROUP was created, Threads parameter was setting to 5, New CONCURRENT_QUEUE manager was created, PERSLM and MSL_PERSON_LIST concurrents were replaced under the new manager, excluded from others..