IGI Subledger Security (SLS) Poor Performance Due To Reparsing Child Cursors Causing High "Cursor: Pin S Wait on X" Wait Events (Doc ID 1967481.1)

Last updated on JULY 14, 2016

Applies to:

Oracle Public Sector Financials (International) - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

In some circumstances the Subledger Security (SLS) code can cause poor performance due to "Cursor: Pin S Wait on X" wait events.
The wait events indicate that during execution of some reports, multiple child cursors for each of the queries in the report are being reparsed.
Since the child cursors are each taking 6+ seconds to hard parse and multiple children are involved the elapsed time can rise from around 10 seconds to several minutes.
 
The main cause of the high number of child cursors is reported by the system to be:

The predicates which contain literals are supplied by functions generated automatically by the Oracle supplied package igi_sls_objects_pkg.

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