Target Version 12.2 & Above
- 1 Minute to read
- Print
- DarkLight
- PDF
Target Version 12.2 & Above
- 1 Minute to read
- Print
- DarkLight
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
Oracle E-Business Suite Release 12.2 introduces Online Patching (OLP), a new feature that significantly reduces the patch downtime that was needed in previous releases. Panaya can greatly assist you in identifying the numerous changes required when implementing OLP.
The Panaya extract (ETL) includes 4 Oracle-supplied SQL scripts (Readiness Reports) that will gather the necessary information about your instance and the OLP. These scripts can be very long-running.
To improve the performance of these scripts, we highly recommend you refresh the SYS and data dictionary statistics to ensure that the database will use the most efficient execution plan.
Suggested commands (to be run at the DBA’s discretion) before the ETL -
- SQL> EXEC DBMS_STATS.GATHER_SCHEMA_STATS (‘SYS’);
- SQL> EXEC DBMS_STATS.GATHER_DATABASE_STATS (gather_sys=>TRUE);
- SQL> EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;
- SQL> EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;