When you migrate to Oracle Exadata, you’re stepping into an ecosystem built specifically for the Oracle Database. With technologies like Smart Scan, Storage Indexes, and Offloading at the storage layer, Oracle says full table scans are fast—so fast, some recommend dropping your indexes altogether.
A very common task is investigating other sessions, since the ones causing problems in our database are often not our own, but application sessions. One very effective tool to determine what they are doing is to trace them. Let’s say we identify a session performing a lot of ...
If you’re working with Oracle Exadata Cloud@Customer (ExaCC), you may encounter unexpected failures when provisioning a new Oracle 23ai database using the standard dbaascli
tooling or Cloud Automation workflows.
During the DBCA (Database Configuration Assistant) execution, the process fails with a fatal error code (DBAAS-60022
) due ...
Continuing the series Back-To-Basics Guide, I tackle the question of When I issue a commit, are the changes immediately written to the datafiles?
To answer this, we first need to understand some of Oracle’s processes and memory structures. I invite you ...
In simple terms, an Oracle Database Instance is a set of memory structures and background processes that manage the database files. Every active Oracle Database must have at least one associated instance.
When you start an instance, it:
If you’re stepping into the world of Oracle or want a refresher, understanding what’s under the hood of an Oracle Database Server is a crucial first step.
This post simplifies the key concepts and architecture of it.
Think of it as ...
In an Oracle Database, the Online Redo Log is a physical structure consisting of a minimum of two files, which can, in turn, be multiplexed into two or more identical copies. These identical copies are known as members of a Redo Log group. As mentioned, the Online Redo ...
The definition of an instance is simple and basic: it is a set of memory structures that manage the database files. When the instance starts, background processes such as LGWR, PMON, etc., also start.
It’s important to know that at least one active or running ...
I had a chat a couple of weeks ago with my mentor on how we are the last of our species that know and drilled down on understanding how the Oracle Database works, so here I am doing a series of blog posts going back to ...
Back at OCW 2022, Safra Catz, Oracle’s CEO said : Moving slowly can be risky, no time play it safe – the winners will be those that make BOLD moves. I think this phrase still holds true and with even more weight to it than before. With the ...
Last week, Oracle Exadata Exascale was released, and it is one of the features that I have been most excited about in a while. I will be writing a couple of blogs around the topic, and in them we will go how to deploy it and technically deep ...
In this third blog post series , we will be creating 4 main compartments
The compartments above are based on the CIS Foundation Architecture, which is an architecture that starts with the compartment design for the tenancy along with groups and policies for segregation ...
In my previous post, I talked about the setup of Terraform and a primer on what it is. In this blog post I will create a simple resource in OCI.
One of the things that I will note, is that in this day and age, Terraform (TF) is ...
I haven’t written a blog in a while, and I feel that I have made a couple of mistakes lately that could have easily been avoided if I had done my tasks as IaC ( Infrastructure as Code). So I will start a series of IaC and Terraform. ...
Migrating an on-premise database to the cloud within a limited timeframe can be a challenging endeavour. I had a High Ed client that put us to the challenge of migrating their Dev/QA and Prod environments to an Exadata Cloud@Customer (ExaCC) environment in under six weeks. In this blog ...