Top 60 Oracle Blogs

Recent comments

Oracle on Azure

Migrating Oracle Exadata Workloads to Azure- Storage Indexes

I’m about simplifying anything for customers as we bring over complex environments into Azure and Oracle databases running on Exadata is a big part of these challenges.  Decoupling the database from the engineered features is a crucial part of my work and with Oracle 19c, having customers running on the terminal release isn’t the only reason to upgrade if the database is on an earlier release.

As I’ve discussed in other posts, blogs and articles, I have numerous ways to address latency when losing cell node offloading, hybrid columnar compression (HCC), thin cloning with sparse clone, flash cache, flash logging, etc., but storage indexes are unique to Exadata that simply have no comparable work around.

Why a One-Week Report for AWR Sizing in Azure

It’s not uncommon for different recommended practices to arise in technical sizing and optimization practices.  For many, it’s a compromise between most optimal data and ease of access vs. impact on production environments, which is no different from what we face when sizing Oracle on Azure.

Prepping an Oracle Database for a Cloud Migration

There’s so much I need to get written down these days, but there’s only so many hours in a day and days in a week and I’ve totally failed in this area.  Well, I have a little time right now, so going to try to get something down.  It only took me four times to get this published! </p />

    	  	<div class=

Oracle on Azure- Sizing vs. Optimizing

As the flood gates open up on Oracle for Azure IaaS, working in an efficient manner has become a necessity.  We’re building out partners to help, but there are ways to empower our customers and those doing this work to make us all successful-  hopefully this post will assist.

After I posted the Estimate Tool for Sizing Oracle Workloads on Azure, I realized more guidance around AWR reports would be beneficial.  These tips will provide help to any migration, not just one to Azure, so read and reap the rewards!

World Backup Day- Backing up an Oracle Database using RMAN to Azure Blob Storage

A DBA is only as good as their last backup…or more so, their last recovery.

To celebrate #WorldBackupDay on Twitter, I’m blogging on how to backup an Oracle database directly to Azure Blob storage.  Yes, you could backup on a managed disk directly connected to the VM, then copy it off, but Azure Blob Storage is inexpensive and provides considerable speed and opportunity to create an NSF mount to use the backups with other Oracle hosts for cloning, recovery, etc.

Configure Blob Storage in the Azure Portal

In this example, we have an Oracle database running on an Azure IaaS VM and need to backup the database with RMAN.  No RMAN repository catalog will be used, but yes, you can use one-  no problem.

If you don’t already have a database and want to play along, you can perform the following blog post to create one.

Create a Simple Oracle VM on Azure IaaS

Use the following shell script to create your Oracle VM.  I chose the following parameters to create mine:

Using Azure Cloud Shell and with persistent storage, which are linked on the github page, I uploaded the script and run it after changing the permissions.

chmod 744

Provision the VM

Run the script:


Anwser the questions from the script:

Exadata Workloads to Azure, Part II

In my last post, I discussed some of the unique challenges migrating Oracle workloads from Exadata to Azure posed.  Engineered systems are not your everyday lift and shift and are rarely simple.

Although I covered some focus areas for success, I’d like to get into the migration philosophical questions around cell offloading and IO.  cell information is referred to in the average Oracle 12c AWR report almost 350 times.  That’s a LOT of data to consider when migrating a workload to a server that won’t have cell nodes to OFFLOAD TO.

If cell nodes are creating a ton of different IO in Exadata and don’t exist in Azure, will it require IO in Azure?

Migrating Oracle Exadata Workloads to Azure

I know, I know-  there’s a number of you out there thinking-

I’m being brought in on more and more of these projects due to a recent change for some Exadata backup components many companies kept onsite, (parts that wear out more often, like PDUs and cell disks) which are no longer an option and that moving to Azure is a viable option for these workloads if you know what to identify and address before the move to the cloud.

Tools To Monitor and Work with Oracle on Azure

I’ve been studying for over a week for my certs.  It really is a challenge for my ADHD brain, as I learn by interacting and using a product, not be reading about it and guess what?  Most of what the certs are on are not in my technical area.  Yeah, this is not fun for me.  I find that my brain hits a limit on what it can absorb before the activity levels in the temporal lobes diminish and I need to take a break, which is what I’m doing right now after a full day of Azure Synapse Analytics, (yes, I know it’s not GA.  Yes, I know I have limited exposure to work with it, which means it’s going to be difficult for me to know at the deep level I’d need for a cert.  Yes, I want to find the person who added this, along with CosmosDB and Polybase as the main content for the cert… :))