UTLRP Is Slow After Upgrading to 12.2 Database, Slowness Observed While Compiling PL/SQL Units
(Doc ID 2445997.1)
Last updated on JULY 19, 2020
Applies to:PL/SQL - Version 18.104.22.168 and later
Information in this document applies to any platform.
After upgrading the database to 12.2 release, compiling invalid objects using utlrp.sql or manual compilation of PL/SQL units is taking lots of time.
- The AWR report may show "library cache lock" or "PGA Memory Operation" wait event at the time of compilation.
- Gathering 10046 trace for the session shows the following short call stack.
Database upgraded to 12.2 release.
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