My Oracle Support Banner

Maintain Security Lists Process Encountering Performance Issue (Doc ID 416877.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle Human Resources - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
PERSLM
SLM

Goal

The "Maintain Person Security List information(Internal)--PYUGEN" is encountering a performance problem. Reviewing a SQL trace with explain plan shows the process executing a particular select statement thousands of times:

"select 1
from per_all_assignments_f ASSIGNMENT,
per_all_people_f PERSON,
per_person_type_usages_f PERSON_TYPE
where ASSIGNMENT.assignment_id ..."

This is showing as the reason that the process is taking a long time.

1) Why is this particular select running so many times?
2) Can we change the fact that it is running?
3) What is the expected run time for Security List Maintenance process?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.