Exadata’s InfiniBand Switch: Incorrect NTP settings Leading to Evictions, and Patching Recommendations

Overview This post describes a recent outage during a routine Exadata (X7-2) patching to the 19.2.12.0.0.200317 release using “patchmgr.” An incorrect configuration of NTP (Network Time Protocol) on the InfiniBand (IB) switches placed all switches in the “discover” state after…

Read More >

Using SQLCODE Function

The idea of this post is to show how to handle errors using SQLCODE function. That function shows the code error for the latest exception when running a PL/SQL code. Here is a small example of code that raises an…

Read More >

ProxySQL Query Rules: Notes From Production

After spending four years working with ProxySQL in production, I’ve learned a few interesting lessons about interpreting and processing query rules. I hope to save you some time (and avoid wrong turns) with this summary of ProxySQL query rules. ProxySQL…

Read More >

Cassandra Vulnerability – CVE-2020-13946 – Apache Cassandra RMI Rebind Vulnerability

On September 1, 2020, Apache disclosed a security vulnerability for Apache Cassandra. Summary: It’s possible for a local attacker without access to the Apache Cassandra process or configuration files, to manipulate the RMI registry to perform a man-in-the-middle attack and…

Read More >

Top Five Recommendations to Accelerate Your Snowflake Adoption

After eight years in business, Snowflake filed its prospectus with the USA’s Securities and Exchange Commission to become a publicly traded company this week (August 24, 2020). Details are here. This is the next step in the history of the…

Read More >

Adding Your RDS Fleet to PMM2 Using the API

PMM (Percona Monitoring and Management) is a great community tool for monitoring your OSDB (MySQL, PostgreSQL, MongoDB) fleet. It’s feature rich, and it’s built and distributed as open-source based on several de-facto industry standard tools such as Grafana and Prometheus….

Read More >

CreateGoldImage Followup – Is CreateGoldImage Required for Cloning Oracle Home?

On October 31, 2019, I blogged about How To Use CreateGoldImage For Cloning In 19c. CreateGoldImage seems like a nice new feature; however, it’s also very buggy. Here are a few bugs: 2641469.1 27432355.8 27432338.8 I received a suggestion to use tar…

Read More >

Query Statspack’s “SQL ordered by” Sections Over a Time Period

In this post, I’ll present the statspack_top_sqls.sql script, which returns SQL performance statistics by mining the Statspack repository. In a previous blog post, I presented the statspack_load_trends.sql and the AWR_load_trends.sql scripts, which provide a high-level overview of workload dynamics on…

Read More >

Postgres partial indexes on email address domains

When I first heard of Postgres partial indexes, I knew immediately that this would have solved a problem I had in MySQL about a decade ago. That problem didn’t go unsolved, but it certainly wasn’t as easy as I’ll demonstrate…

Read More >

Postgres Security Patches Related to the Search Path

There were some security patches released this month for Postgres, to put further restrictions on pathways that malicious users could use to leverage the search_path to insert malicious code. What is the search path? What is search_path? Postgres has a…

Read More >
Page 4 of 365« First Page...23456...10...Last Page »