Nigel Bayliss

Product Manager

Nigel is the product manager for the Oracle Optimizer. He's worked with Oracle technology since 1988 and joined Oracle in 1996. He's been involved in a wide variety of roles including development, benchmarking, consulting and pre-sales. 

Recent Blogs

Migrating to Oracle Autonomous Database with Real-time SPM

If you're thinking of migrating to Oracle Autonomous Database 19c or 23c from an on-premises or BaseDB 19c database, you can use real-time SQL plan management to protect yourself from SQL performance regressions caused by plan changes. This post tells you how.

What is Real-time SQL plan Management?

Real-time SQL plan management (SPM) is available in Oracle Database 23ai and Oracle Autonomous Database 19c.

SQL Plan Management Cheat Sheet - Part 2

This blog post deals with SQL plan management capture, SQL statements with multiple plans and SPM evolution.

Secure View Merging in Oracle Database 23ai

The database parameter optimizer_secure_view_merging has been depricated. Use the "merge any view" privilege instead.

Using the Automatic SQL Tuning Set in Oracle Database 19c

This blog post describes how to use the automatic SQL tuning set (ASTS) in Oracle Database 19c on-premises/self-managed databases.

Receive the latest blog updates