How to Apply Release Update 12.2.0.1.210420 (Patch 32507738 – April 2021 RU)

Oracle recently released its April 2021 Release Update for 12cR2 (Patch 32507738). This post is to cover patching of Oracle 12cR2 database with this latest RU. (For 19.11 RU please read How to Apply Release Update 19.11.0.0.0 (Patch 32545013)).   Step-1: Install Latest OPatch First Step of Any Patching Process is to download and install…

Understanding TKProf output

In the previous post (Oracle TKProf Usage), we saw how to generate a SQL Trace and then how to format it using TKProf. In that post we create a trace for following SQL statement:- select * from all_objects; In this post we would interpret TKProf output of that SQL query. Following is the TKProf Output…