Installation and Configuration of the new Oracle ASMLib v3.1 on Oracle Linux 9

Introduction Following the recent announcement of the deprecation and desupport of the Oracle ASM Filer Driver (ASMFD), and the release of a new version of the Oracle ASMLib for Oracle Automatic Storage Management (ASM). It's the perfect time to revisit ASMLib and write a blog on how to download, install, and configure the ASM library... Continue Reading →

Automated Oracle Database Refresh with Workato

Introduction I recently had the opportunity to spend some time learning all about the Workato orchestration platform. After completing the Workato training paths and certifications I decided it was time to take my new found knowledge out for a spin. In the short video at the end of this post I will demonstrate how a... Continue Reading →

Oracle Database Storage Array Usage and Data Reduction Ratio Analysis

I was recently asked Does a Pure Storage FlashArray include empty, unused Oracle Database space within its data reduction calculation ?. As I am sure many others may have had the same question, I thought it would make a good topic for a blog post, so here we go. FlashArray Data Reduction From the FlashArray... Continue Reading →

Oracle ASM Filter Driver (AFD) Filtering and 5.15 UEK7 kernels

Background As a long time fan of the Oracle ASM Filer Driver, one of the major benefits for Oracle ASM Filter Driver (AFD) is AFD Filtering. AFD can ensure writes are only performed by trusted and registered Oracle processes, blocking potentially damaging writes that would have otherwise resulted in data corruption. Unfortunately, a recent Linux... Continue Reading →

Reclaim Storage space using the Oracle ASM Filter Driver (ASMFD)

Background Ok, what is the Oracle ASM Filter Driver ? The Oracle ASM Filter Driver (Oracle ASMFD) is an Oracle provided Linux kernel module that resides in the IO path of the Oracle ASM disks. Oracle ASMFD provides a number of advantages over the use of ASMLIB and UDEV managed volumes, these include: storage protection... Continue Reading →

Working with Oracle Linux 8 and iSCSI

Oracle Linux Server Configuration For this blog post I will be using an Oracle Linux 8 server and a Pure Storage FlashArray to demonstrate how block volumes can be presented to an Oracle Linux 8 database server via iSCSI. Let's start by logging in as root and configuring the Linux database server to support Internet... Continue Reading →

Getting Up and Running with Oracle 19c on NFSv3

Background As many of you may already know, I have been a long time supporter of running Oracle on NFS, having deployed many Oracle E-Business suite, single instance and RAC databases on NFS over years. However, for many Oracle DBAs NFS (Network File Systems) is still something of an unknown entity, in this post I... Continue Reading →

How to Influence Physical IO sizes with Oracle MBRC

I recently published a blog on restricting Linux block storage IO sizes using Kernel settings, but what if you don't have root access, or want a more dynamic approach for your Oracle Database. In this blog post I am going to explore the use of multiblock read count (MBRC) on an Oracle 19c Database. Oracle... Continue Reading →

How to reduce Linux Block Storage IO sizes

A colleague recently asked me an interesting question, How can I reduce the size of a physical IO on Linux? So here's a blog that hopefully answers that question. Linux Operating System For this blog I will be using a Linux server with a Kernel that has a default maximum size of 1280KB (if you... Continue Reading →

How to dump MySQL data to S3 Compatible Object Storage using the MySQL Shell

In Part 1 of this blog series I shared how to create a Pure Storage FlashBlade S3 compliant Object Storage account, user and bucket. I also demonstrated how to download the MySQL airportdb database, and upload objects into the Object Store S3 bucket. In Part 2, I showed how we can use the MySQL Shell... Continue Reading →

Create a website or blog at WordPress.com

Up ↑