GigaOm x Pythian: Realities and Risks of Enterprise AI
In a recent interview on the Business Disruptions in Tech podcast, Howard Holton and ...

Oracle Patching of Databases (DB) and Grid Infrastructure (GI) is a routine and recommended process for any Oracle ...


Exadata X8-2 comes with up to 3 Petabytes (PB) of raw disk capacity. This post briefly explains the basics of capacity ...

Since its launch in 2017, Google Cloud Spanner has built a reputation that’s very different from traditional databases. ...

This post is about a Statspack anomaly I discovered while analyzing execution trends of a particular SQL on one of our ...
I have recently received a requirement to provide a daily automatic AWR report, and it should be delivered to the DBA ...

More and more companies are adopting the Always On Availability Groups as their HA/DR architecture for the SQL Server ...

Background I was conducting regular OS patching of all the Exadata components when one of compute nodes caused ...

It’s no secret that many companies have been moving existing on-premises environments to the cloud. They all have ...

In my previous post I showed you how to use dbt to expedite data preparation tasks on Google BigQuery. This time, I’ll ...

Background I ran into a situation where we needed to restore just one dropped (and recreated) pluggable database (PDB) ...

Background I ran across an interesting case within OEM 12 (Oracle Enterprise Manager) Release 5. A client reported the ...

This is a blog post about an issue that can occur during a database upgrade and produces a misleading error message. If ...

Introduction Recently one of our colleagues was struggling with the default self-signed SSL certificate that ships with ...

Introduction to Autonomous Health Framework (AHF) I wanted to share a brief summary–a cheat sheet–to highlight the ...
Apex Interactive Report In a couple of cases, we want to have a button (or an image) added to an IR column working with ...

Background One of our clients had issues with their scheduler jobs in DEV and PROD databases and all scheduler jobs ...

Context Oracle Auto Service Request (ASR) is a secure, scalable, customer-installable software feature of warranty and ...

This post shows how to use cloudspannerecosystem/scheduled-backups to configure scheduled backups for your cloud ...

From time to time, a simple request to reorganize space in a tablespace leads to a more complex solution. Here’s how we ...

As you might know, each Exadata cell contains 12 physical disks with a fixed size. If you want to increase the ASM disk ...

I received the above message related to an ORA-7445 on my 11.2.0.4 database: ORA-07445: exception encountered: core ...
While setting up a SQL Server job to execute a PowerShell script, I ran into an issue with the service account failing ...

How you access and retrieve data is crucial to your database’s performance and resilience: the more transactional or ...

Intro When investigating why an Oracle job is taking a long time to execute, normally the DBA will identify the DML ...

From ORAchk/EXAchk/ODAchk, Database Security Assessment Tool (DBSAT) and Hang Manager, to Cluster Health Advisor (CHA), ...

This is the third in a series that covers the details to deploy a high-available setup of Oracle Enterprise Manager ...

During the Oracle E-Business Suite migrations from on-premise to AWS Cloud (similar to any cloning exercise), you may ...

This is the fourth in a series of blog posts that covers the details to deploy a high available set up of Oracle ...

What are the licensing considerations for deploying Oracle Enterprise Manager and using OEM for monitoring database ...