Fahd Mirza on AI, Cloud, DevOps and Databases

Understanding Read-Only Options in Oracle: Instances vs. Databases

When it comes to limiting data modifications in Oracle, two options are available: Read-Only Insta…

Session Monitoring and Session Cleanup in Oracle

As an Oracle database administrator, managing sessions is crucial for maintaining performance and …

Troubleshooting ORA-1652 by Identifying Temporary Segment Usage

I still get bit anxious when I receive this ORA-1652 error in production databases but its a hard n…

Estimating Query Execution Time in Oracle

As an Oracle database administrator or developer, running heavy, long-running, and critical produc…

Oracle Database Connections with Oracle Functions

As a developer, connecting to databases can be a hassle. But what if you could leverage a serverle…

Oracle Database Migration with Supplemental Logging

As an Oracle database administrator, I've come to appreciate the power of supplemental logging,…

Temp Tablespace Matters in Oracle

When managing Oracle temporary tablespaces, it's important to prioritize timely data commitmen…

Access AWS S3 Bucket from Oracle Database

If you want to access any object stored in an AWS S3 bucket from Oracle database, then dbms_cloud …

How to Identify Oracle Database Orphan Sessions

In the world of database management, particularly with Oracle databases, "orphan sessions&quo…

Integrate Oracle Logs with Cloudwatch

If you are running Oracle database on AWS RDS, then you must integrate Oracle alert log and listen…

Difference Between OCI Compartments and AWS Azure GCP Offerings

One of the key foundational concepts in Oracle Cloud is Compartments. If you have worked in AWS t…

Tips to Become an Oracle ACE

Thanks Oracle for Oracle ACE Swag

Just received my Oracle ACE swag for this year and I felt the same excitement and pride which I fe…

Venerable FRA Error Rears Its Head Again in Oracle Database

After a long time, I encountered the good old, very familiar FRA error in one of my older database…

Transportable Tablespaces for Oracle Database Migration to Oracle Cloud

More and more Oracle databases are being lifted from on-prem and migrated over to Oracle cloud. Th…

Handy Query to Compare Objects in Multiple Oracle Databases

As a DBA, more than often than not, you need to compare database objects in different databases. Th…

20 Advantages of Oracle Container Engine (OKE)

Kubernetes is a de facto standard for Container orchestration. Every cloud provider include Oracle…

Nginx Reverse Proxy for Oracle Databases

Nginx is an open-source, fast, lightweight and high-performance web server that can be used to ser…

Oracle Kubernetes Engine Tutorial for Beginners

Like other cloud providers, Oracle Cloud Infrastructure (OCI) also offers managed Kubernetes which…

Oracle Database TNS Troubleshooting with Netstat

Oracle databases, no matter if they are in cloud or on-prem or of what version, work on client ser…