I had a customer who complains about performance issues on one of the oracle production database. Environment Oracle Database 12c R1 (188.8.131.52) on Linux with Oracle RAC (two nodes). To start with, I collected some AWR reports around the complain time, and I found the top wait events (most of the time) as follows: So, … Continue reading Oracle Database Performance Issue: High waits for “PX Deq: Slave Session Stats”
Following is a list of all RU (Release Updates) and RUR (Release Update Revisions) issued for the Oracle Database 19c (19.3) since Apr-2019 till today 24-Jun-2021. Please zoom-in to see the above picture clearly, or see it partitioned below: Please note that:– Both RUs & RURs are released quarterly (Jan, April , Jul & Oct).– … Continue reading Oracle Database 19c Release Updates (RUs) and Release Update Revisions (RURs)
When trying to run opatch on windows, I got the following error: \QuickTime\QTSystem\QTJava.zip was unexpected at this time. After some research, I found that this error is due to spaces in the value of the CLASSPATH variable. Here, we have a couple of solutions: Solution #1 Remove "C:\Program Files (x86)\QuickTime\QTSystem\QTJava.zip" from the CLASSPATH, we don't … Continue reading opatch error \QuickTime\QTSystem\QTJava.zip was unexpected at this time.
While applying Patch 31210848 "Microsoft Windows 32-Bit & x86-64 Bundle Patch 184.108.40.206.200714" on database 220.127.116.11on Windows platform I got the following error: Unable to lock Central Inventory. OPatch will attempt to re-lock. Solution: I opened another command window as Administrator, and applied the patch again. This time, it completed successfully without errors: For Windows platform, … Continue reading OPatch error : “Unable to lock Central Inventory”