Forum Stats

  • 3,873,047 Users
  • 2,266,500 Discussions
  • 7,911,412 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: