Richard Foote's Blog

Subscribe to Richard Foote's Blog feed Richard Foote's Blog
Focusing Specifically On Oracle Indexes, Database Administration and Some Great Music
Updated: 5 days 21 hours ago

Announcement: “Oracle Performance Diagnostics and Tuning” Webinar – 20-23 August 2019.

Tue, 07/30/2019 - 11:05
I have just scheduled a new “Oracle Performance Diagnostics and Tuning” webinar to run between 20-23 August 2019, specifically for my friends in New Zealand, but is open to anyone. It will run between 7am-11am AEST each day, which is perfect for those in NZ, but also other parts of the world such as Western […]

Oracle 19c Automatic Indexing: Configuration (All I Need)

Mon, 07/29/2019 - 05:12
In this post, I’ll discuss how to configure the new Automatic Indexing capability introduced in Oracle Database 19c. The intent of Oracle here is to make the configuration of Automatic Indexing as simplistic as possible, with as few levers for DBAs to potentially stuff up as possible. The ultimate goal would be to have a […]

Oracle 19c Automatic Indexing: Methodology Introduction (After Today)

Wed, 07/24/2019 - 04:27
For the past month or so I’ve been playing around extensively with the new Oracle 19c “Automatic Indexing” feature, so I thought it was time to start blogging about it. Considering it’s only in “Version 1” status, my initial impression is very positive in that it works extremely well doing at what it’s initially designed […]