Auditing Individual Functions/Procedures inside a PL/SQL Package

I got this question from one of my clients:How can I Audit Individual Functions/Procedures inside a PL/SQL Package?. Let us build a quick demo: This is just a sample package Let us try to enable this type of auditing using the following command:audit execute on scott.emp_pack.CreateEmp by access;I got the following error: As per Oracle … Continue reading Auditing Individual Functions/Procedures inside a PL/SQL Package

Oracle Database Performance Issue: High waits for “PX Deq: Slave Session Stats”

I had a customer who complains about performance issues on one of the oracle production database. Environment Oracle Database 12c R1 (12.1.0.2) 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”

Oracle Database 19c Release Updates (RUs) and Release Update Revisions (RURs)

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)

Oracle Database 12.2.0.1 Release Updates (RUs) and Release Update Revisions (RURs)

Following is a list of all RU (Release Updates) and RUR (Release Update Revisions) issued for the Oracle Database 12cR2 (12.2.0.1) since Jul-2017 till today 20-Jun-2021. Please zoom-in to see the above picture clearly, or see it partitioned below: Please note that: - Both RU & RUR are released quarterly (Jan, April , Jul & … Continue reading Oracle Database 12.2.0.1 Release Updates (RUs) and Release Update Revisions (RURs)

Oracle Database 21c Documentation

Oracle Database is the world's most popular database. Available on cloud and on-premise platforms, Oracle Database 19c is the most recent long term release, with an extended support window. Oracle Database 21c is the latest innovation release, initially available on Oracle cloud through Autonomous Database Free Tier and Database Cloud Service. For Oracle Database 21c documentation:https://docs.oracle.com/en/database/oracle/oracle-database/21/index.html For Oracle Database … Continue reading Oracle Database 21c Documentation