Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
utlrp.sql running abnormally long
Rupdipta
Member Posts: 1 Green Ribbon
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: