About the Author

Nigel Bayliss

Product Manager

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

Posts by Nigel Bayliss:

Adding and Disabling Hints Using SQL Patch

If you’re a DBA, it’s likely that you’ve encountered systems where a lot of SQL statements have been hinted almost as a matter of policy. Perhaps you’d like to...

Monday, June 12, 2017 | Read More

Efficient Statistics Maintenance for Partitioned Tables Using Incremental Statistics – Part 3

Introduction This post covers how Oracle has improved incremental statistics for partitioned tables in Oracle Database 12c Release 2. If you’re not already...

Thursday, March 23, 2017 | 12c | Read More

Upgrade to Oracle Database 12c and Avoid Query Regression

Those of you that made it to the demo grounds at Oracle Open World this year (it’s still just about 2015) will have had the chance to chat with the Oracle...

Friday, March 10, 2017 | SQL Plan Management | Read More

Optimizer Adaptive Features and Upgrading to Oracle Database 12c Release 2

Introduction Here's a reminder of the changes we’ve made to the optimizer’s adaptive feature settings in Oracle Database 12c Release 2. The new default behavior...

Wednesday, March 1, 2017 | 12c | Read More

New Optimizer Statistics White Paper

A new white paper on Oracle Optimizer statistics is now available. Just go to the Query Optimization page in OTN and click the Understanding Optimizer...

Wednesday, March 1, 2017 | 12c | Read More

New SQL Plan Management White Paper

A new white paper for SQL Plan Management is now available. Just go to the Query Optimization page in OTN and click the SQL Plan Management with Oracle Database...

Monday, January 30, 2017 | SQL Plan Management | Read More
 

Visit the Oracle Blog

 

Contact Us

Oracle

Integrated Cloud Applications & Platform Services