1. Performance Tuning Guide
  2. SQL Patches

SQL Patches

SQL Patches can be transported via Oracle SQL Repair Advisor. The DBMS_SQLDIAG package provides the following to create a staging table, pack the SQL patches and place them in the staging table in source database, and unpack after it has been moved to target through Exp/Imp or Data Pump:

  • CREATE_STGTAB_SQLPATCH: In a schema other than SYS
  • PACK_STGTAB_SQLPATCH: Imports SQL patches (all or selected ones)
  • UNPACK_STGTAB_SQLPATCH: Imports back into dictionary in Target database