Blog

Good quality statistics are essential to be able to generate optimal SQL execution plans, but sometimes statistics can be of poor quality and this fact...

This article deeply analyzes the operational mechanisms of Oracle's four core access paths (Full Table Scan, Index Range Scan, Index Fast Full Scan, and Index...

A comprehensive guide on using the MAX_STRING_SIZE=EXTENDED parameter in Oracle, including benefits, risks, and implementation steps. This article covers the theory, practical scenarios, and a...

In order to select an optimal execution plan the optimizer must have representative statistics. Representative statistics are not necessarily up to the minute statistics but...

Introducing Inspect4Oracle: A powerful, open-source Oracle database inspection tool. Simplify daily checks, troubleshoot performance, and gain comprehensive insights with an intuitive web UI and interactive...

This paper will discuss in detail, when and how to gather statistics for the most common scenarios seen in an Oracle Database.

A detailed case study of a critical ERP system outage triggered by full Oracle archive logs. This post walks through the emergency response, analyzes the...

This document aims to introduce the classification, application scenarios, and recommended usage of indexes associated with partitioned tables in ORACLE databases through a Q&A format....

A deep dive into the critical Oracle database configurations essential for successful Oracle GoldenGate (OGG) deployment across various versions (10g, 11g, 12c, 19c), drawing from...