BigDBA – Database,Devops,Big Data,Cloud & Oracle Blog

If you’ve ever had to move a multi-terabyte Oracle database between platforms say from Solaris SPARC to Linux x86-64 you already know the classic Transportable Tablespace export/import can lock your tablespaces in READ ONLY for hours, sometimes days, while the metadata export crawls along. That’s where XTTS (Cross Platform Transportable Tablespaces with RMAN Incremental Backu...

If your E-Business Suite environment is still sitting on an older release — anywhere between 11i and 12.1 and the database side has already been taken care of (upgraded to 19c with the latest RUP applied), this guide covers everything that’s left on the application side. It follows the official Oracle E-Business Suite Upgrade Guide for Release 12.2, and pulls in extra guidanc...

In real-world data science, we rarely find all our data sitting neatly in a single database. More often, it is scattered across different departments and technologies. You might have legacy transactional records in a robust Oracle database, modern relational user profiles in PostgreSQL, and unstructured, high-volume event logs...

One of the biggest paradigm shifts for a Database Administrator (DBA) moving from Oracle to PostgreSQL is the loss of built-in, automated tuning advisories. In the Oracle ecosystem, the Automated Workload Repository (AWR) and the Automatic Database Diagnostic Monitor (ADDM) work around the clock. They don’t just log errors; they actively anal...