Oracle Database Hangs – FRA Space Issue

Posted on by Ahmed Abdel Fattah

Although I feel (or claim) that I know how the FRA is working and I know much about the FRA mechanics, encountering FRA space issues consistently leads me to discover new insights and learn something new (very new). What was the issue? The Archiving process stopped working due to space shortage in the +FRA Disk … Continue reading Oracle Database Hangs – FRA Space Issue

Monitoring Oracle Database using Python

Posted on by Ahmed Abdel Fattah

In this video I'll navigate around an application that I built using Python to monitor the oracle database performance. The main packages that I used to build this application are: Streamlit, Pandas and plotly. In the future, I may share how I built this application in detail, but here I just need to highlight that … Continue reading Monitoring Oracle Database using Python

Oracle Database Cloud Service Provisioning is very slow

Posted on by Ahmed Abdel Fattah

While creating an oracle Database cloud service (or the new name “Oracle Base Database”): and after passing all the required information, and then clicking “Create DB System”, it started to provision the database system: The problem here is that it takes very long time to provision, I waited for 1 hours, 2,3,4 hours without luck. I … Continue reading Oracle Database Cloud Service Provisioning is very slow

Database Cloud Service Provisioning Fails With “Cannot access Object Storage using the subnet with the following OCID”

Posted on by Ahmed Abdel Fattah

While creating an oracle Database cloud service (or the new name "Oracle Base Database"), and after passing all the required information, and then clicking "Create DB System", I received the following error:Cannot access Object Storage using the subnet with the following OCID: ocid1.subnet.ocx.zz-yyy-xxxxxx-1.aaaaaaaaxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx. Review your VCN configuration. If you need further assistance, contact Oracle Support. … Continue reading Database Cloud Service Provisioning Fails With “Cannot access Object Storage using the subnet with the following OCID”

Auditing Individual Functions/Procedures inside a PL/SQL Package

Posted on by Ahmed Abdel Fattah

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”

Posted on by Ahmed Abdel Fattah

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)

Posted on by Ahmed Abdel Fattah

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)