Search

Top 60 Oracle Blogs

Recent comments

Azure

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.

Join Performance for UUID, STRING, and INTEGER with CockroachDB

overview

To continue on the UUID performance thread, I was recently asked by a customer how joins perform with various data types. I had not run a specific test, but suspected perform would be driven mostly by the size of the data types.

I wanted to verify my assumptions with real test data that shows the core performance of joins with CockroachDB.

the schema, data, and queries

For this test, two tables were created. The first table had one million rows and the second table had 200k matching primary keys for UUID, STRING, and INTEGER data types.

schema:

create table u1 (id uuid primary key);
create table u2 (id uuid primary key);

create table s1 (id string primary key);
create table s2 (id string primary key);

create table i1 (id integer primary key);
create table i2 (id integer primary key);

data load:

2020 PASS Summit and the Azure SQL Championship

I barely have enough time to breathe let along blog these days, but lucky for me, I am taking some downtime today, so I can come out here and write!

Anyway, since I’m so busy, I volunteered to help judge the Azure SQL Championship that you can be part of!

Ingest format performance with UUID using CockroachDB

Recently, I have been working with customers that have been concerned about the performance of various UUID formats. Other products have various performance characteristics for inserting, generating and presenting UUID data.

For this blog, I ran a quick series of tests using jmeter insert data along with some simple SQL tests to generate UUID values. Hopefully, this will be helpful to better your understanding of UUID with CockroachDB.

UUID formats

Cockroach DB has four different ways data can be formatted for use with the UUID data type.

String format
'63616665-6630-3064-6465-616462656564'

Curly Brace format
'{63616665-6630-3064-6465-616462656564}'

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 />
</p></div>

    	  	<div class=

Two Years at Microsoft

This is commonly the time at any company I discuss how I’m about to move on…

Nope, not planning on going anywhere… I know, it’s odd for everyone involved, but we’ll all get used to it.

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 mk_oravm.sh script and run it after changing the permissions.

chmod 744 mk_oravm.sh

Provision the VM

Run the script:

 ./mk_oravm.sh

Anwser the questions from the script:

Locating Oracle Enterprise Linux Images for Azure

Just like with other UI’s, the Azure portal may not show you the wealth of offerings that can be found in the Azure catalog.  For those Oracle DBAs hoping to build an IaaS VM image from a certified OS version, this means they need Oracle Enterprise Linux and are frustrated when they can’t locate it in the portal.

Empower with the Cloud Shell

Oracle DBAs rarely are fascinated with user interfaces or portals, so when you offer us something like the Azure Cloud Shell, it’s something we should embrace.  I’ve spoke about it before and I will rave about it again here.  If you haven’t set it up, skip the download to your desktop and simply go to Azure Cloud Shell and connect to your Azure account.  Once there, ensure you’ve set the CLI to BASH and use this just as you would Putty or Xterminal.