SCRTY_SJTDLY Slow Performance After Upgrade to Oracle 11g, Version 11.1.0.7

(Doc ID 1288131.1)

Last updated on MAY 09, 2016

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 8.9 to 9.1 [Release 8.9 to 9]
Information in this document applies to any platform.
***Checked for relevance on 23-Sep-2013***
***Ownership of the document transferred to ROXANA MARTINELLI on May 9-2016***

Symptoms

 

SCRTY_SJTDLY has slow performance when processing SJT_PERSON. Run times can exceed 10 hours.  When the Nightly SJT Refresh Process is run, the call SCRTY_SJTUPD.25DelTyp.Step01 is being executed thousands of times. It sometimes chooses a full table scan against the PS_SJT_PERSON table to do its delete. This is taking up to 15 seconds per execution causing the job to run for up to 9 hours.

Navigation: Set Up HRMS, Security, Core Row Level Security, Nightly SJT Refresh Process

The Application Engine SCRTY_SJTDLY is running very slowly, sometimes not completing in a single day. The issue is SQL object SEC_PPLJOB_FUTWHERE. The statement is used with Security Access Type 001 Job Department Tree.



Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms