A technical resource for Data Professionals
In this blog post I will share how the Oracle UTL_HTTP package can been used to enable full stack automation by calling external application and infrastructure REST APIs from within an Oracle 19c or 21c database. I have previously shared how to perform File System snapshots on a Pure Storage FlashBlade using the UTL_HTTP package, in this... Continue Reading →
In this blog post I will share how the Oracle UTL_HTTP package can been used to enable full stack automation by calling external application and infrastructure REST APIs from within an Oracle 19c or 21c database. For the purpose of this post I will be using an Oracle 21c database and a Pure Storage FlashBlade... Continue Reading →
In this post I will share to how to create an external table using the DBMS_CLOUD package and then run a query against a csv file uploaded into a Pure Storage FlashBlade S3 Object Storage bucket. I have previously shared how to install and configure the Oracle DBMS_CLOUD package, if you want to follow this... Continue Reading →
The DBMS_CLOUD package has been available for on-premises 19c database for over a year now, and since the initial 19.9 release several fixes have been shipped, so I suggest you consider using the latest patch if possible, to avoid any known issues. I have previously shared how to configure an Oracle 19c database to use DBMS_CLOUD... Continue Reading →
Traditional disk based storage systems use a sector size of 512 bytes, some all-flash-arrays use 4K sectors sizes, but it's not something we generally consider, do you know what you are using ? If you're not sure you may want to check-out now of my recent posts on how to check disk sector sizes from... Continue Reading →
I was recently asked 'How can I check to see if my storage supports 4K sector sizes, and if my Oracle 19c database is using it' ? In this post I will share how to check disk sector sizes from Linux, from Oracle Automatic Storage Management (ASM) and via the Oracle kfed utility. Traditional disk... Continue Reading →
In this post I will share how to perform an online move of an Oracle 19c RAC database to a Pure Storage ActiveCluster Pod to provide Active-Active synchronous replicated storage for an extended / stretched Oracle RAC cluster. Step 1 - ActiveCluster Pod The first step is to create a Pod, in the example below... Continue Reading →
In this post I will share how to use the Portworx Container Storage Interface (CSI) with the Oracle Container Engine for Kubernetes, more commonly known as Oracle Kubernetes Engine (OKE) to Create, Snapshot, Clone, Resize, Restore and Delete Kubernetes Persistent Volume Claims (PVCs) Create a StorageClass (SC) Let's start by creating a new Portworx Storage... Continue Reading →
In this post I am going to share how to backup Portworx Data Services (PDS) managed Kubernetes databases to Oracle Cloud Infrastructure (OCI) S3 Object Storage buckets. OCI Object Storage Create OCI Bucket Logon to Oracle Cloud Infrastructure (OCI) and from the Dashboard select Object Storage or via the hamburger menu navigate to Storage -> Object Storage -> Buckets. Select your required Compartment,... Continue Reading →
Introduction In this blog post I will introduce Portworx Data Services (PDS) and demonstrate how it an be used to also deliver PostgreSQL databases. I have previously shared how we can use the EDB Kubernetes Database Operator to deliver a PostgreSQL database, and also the YugabyteDB Kubernetes Database Operator to deliver a PostgreSQL compatible Yugabyte... Continue Reading →