How to delete an RAC Database Using DBCA silent mode

I was recently working on a Proof Of Concept to migrate RAC non-CDB to CDB. I faced multiple issues and wanted to start fresh. In order to do this, I needed to delete the newly RAC CDB database. Review database…

Read More >

How to Implement Airflow Best Practices from a Data Scientist’s perspective – Part 1

This blog post is a compilation of suggestions for best practices drawn from my personal experience as a data scientist building Airflow DAGs and installing and maintaining Airflow. Let’s begin by explaining what Airflow is and what it is not….

Read More >

How to Prevent Linux 7 Housekeeping from Breaking Oracle

Linux 7 introduced multiple changes and enhancements to the kernel. Among them was automated housekeeping for temporary files. In version 6, tmpwatch is available to manage unused files in temp directories. It can be scheduled via cron to automatically keep…

Read More >

Comparing Pgpool-II and PgBouncer

While I was in the process of determining different HA solutions for PostgreSQL, Pgpool and PgBouncer both came into the equation on multiple occasions.  So I decided to evaluate them and determine what kind of performance they could handle.  I…

Read More >

How to Find Cluster Resources Where Target!=State

DBA typically checks cluster resources as part of patching efforts. However, when checking cluster resources returns 200+ results, it’s not feasible to verify the results and it’s too time-consuming. A better solution is to find a cluster resource where the…

Read More >

Comparing Data Science at an AI Startup and a Consulting Company

The difference between data science consultants and a data science team at a company depending on machine learning (ML) solutions is significant. In the first instance, the consultants need to have a good understanding of both the business and technology….

Read More >

How To Resize Oracle ACFS Volume

There may be many reasons as to why Oracle ACFS volume would need to be resized. Current Filesystem for ACFS is 299G. Free_MB is 872 which causes paging due to insufficient FREE space from ASM Disk Group ACFS_DATA. Option 1…

Read More >

Three Cs to secure against leaks like Capital One

It was revealed today that about 100 Million records were leaked from Capital One and because the press has published court documents pertaining to this case, at least some details are known. According to that, data was stored in cloud…

Read More >

How to Set Up REPMGR with WITNESS for PostgreSQL 10

This blog post will go over how to set up and implement repmgr which is the PostgreSQL application to manage replication between primary and replica nodes, allowing for quick and easy failover and rebuilding of replicas. For reference, all commands…

Read More >

Datascape Podcast Episode 35 – Google Cloud Bigtable with Sandy Ghai

Today on the Datascape Podcast we are joined by Sandy Ghai, who is the Product Manager for Google Cloud Bigtable. Sandy is here to discuss her work and the ever-changing world of the cloud and why it is so exciting….

Read More >
Page 2 of 34712345...10...Last Page »