Forum Stats

  • 3,824,756 Users
  • 2,260,414 Discussions
  • 7,896,306 Comments

Discussions

utlrp.sql running abnormally long

We have recently upgraded our Oracle EBS 12.1.0.2 database to 19c (19.12). However, after upgrade utlrp.sql for compiling invalids is running abnormally long. In the latest upgrade iteration it tool around 12 hrs to compile 120K invalids.

Need help to check for solution that would bring down the compilation time. Please guide what we need to check on server/database configuration that can help to redule the time.

Tagged: