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: 3 days 1 min ago

AUSOUG Connect 2019 Conference Series

Wed, 08/21/2019 - 08:26
  AUSOUG will again be running their excellent CONNECT 2019 conference series this year at the following great venues: Monday 14th October – Rendezvous Hotel In Melbourne Wednesday 16th October –  Mercure Hotel in Perth As usual, there’s a wonderful lineup of speakers from both Australia and overseas including: Connor McDonald Scott Wesley Guy Harrison […]

Oracle 19c Automatic Indexing: My First Auto Index (Absolute Beginners)

Mon, 08/19/2019 - 09:21
I am SOOOO struggling with this nightmare block editor but here goes. Please excuse any formatting issues below: I thought it was time to show the new Oracle 19c Automatic Indexing feature in action and what better way than to go through how I created my first ever Automatic Index. To start, I create a […]

2019 Public Appearances (What In The World)

Thu, 08/15/2019 - 02:29
I’ll be presenting at a number of Oracle events over the remainder of the year. Details as follows: Oracle Open World – San Francisco (16-19 September 2019)

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 […]