Performance issue on post upgrade of EBS database to 12.1.0.2

Performance issue on post upgrade of EBS database to 12.1.0.2

Introduction: We have recently upgraded a database from 11gR2(11.2.0.4) database to 12cR1(12.1.0.2) on EBS environment. Although the whole upgrade process went well, but on post upgrade – we have encountered performance slowness on database queries while accessing few...
Datapatch in 12c Oracle database

Datapatch in 12c Oracle database

Introduction: Prior to 12c, the post patch steps as part of CPU/PSU/Bug fixes are required to run manually on the database to update the patch registry when the RDBMS patch is applied on an Oracle Home. Where as in 12c, we have a new Post Patch SQL Automation tool...