IGI Subledger Security (SLS) Poor Performance Due To Reparsing Child Cursors Causing High "Cursor: Pin S Wait on X" Wait Events
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.
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.
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