I'm Nigel Bayliss. I work for Oracle. The opinions expressed here are my own. I'm the Oracle Optimizer PM and my background is doing stuff with very large DBs.

Joined May 2014
5 Photos and videos
25 Nov 2024
At DOAG I was asked an interesting question about real-time SPM and runaway/terminated SQL. I didn't know the answer for sure, but I do now. Scroll to the bottom of blogs.oracle.com/optimizer/p… for a new ADB demo.
1
8
16
688
24 May 2024
If you use the optimizer_secure_view_merging DB parameter, check out the change in Oracle Database 23ai blogs.oracle.com/optimizer/p…
9
12
1,098
14 Feb 2024
Automatic SPM is now available in #Oracle #Database #19c RU 19.22 EE blogs.oracle.com/optimizer/p…

17
30
3,967
VLDB Bayliss retweeted
ANNOUNCING #tvdpdays 2022 The hybrid event is scheduled on September 28/29. This year’s speakers are @vldbb @JLOracle @richardfoote @OracleSK #ShasankChavan @OracleDBTuning @MartinKlierDBA @martinberx @dani_schnider and me. Check out the agenda... trivadis.com/en/events/perfo…

1
13
26
VLDB Bayliss retweeted
24 Sep 2021
It's Follow Friday, so here are some awesome @OracleDatabase Product Managers you should be following @thatjeffsmith @vldbb @yasinbaskan @krisrice @KnownAsMarkus @ashishray @GeraldVenzl @jtsaismith @AnnamalaiMelli @hiphopengineer1 @ChrisRSaxon @Loic__Lefevre @dohdatabase
2
10
38
VLDB Bayliss retweeted
Follow Friday - some core @OracleDatabase Product Managers @yasinbaskan @dohdatabase @KnownAsMarkus @SQLMaria @GeraldVenzl @jtsaismith @vldbb @RACMasterPM @AnnamalaiMelli @hiphopengineer1 @ChrisRSaxon @Loic__Lefevre Follow all 12 and I'll follow you back :)
5
13
32
3 Aug 2021
Here's the first follow-up post as promised. It's on extended statistics and includes links to some utility scripts for you to grab and adapt. blogs.oracle.com/optimizer/e…

3
12
20 Jul 2021
I am going to write a short series of posts on improving cardinality estimates. This is the intro blogs.oracle.com/optimizer/s…

2
8
30
29 Jul 2020
Some information on the Automatic SQL Tuning Set blogs.oracle.com/optimizer/t…

1
12
30
29 Apr 2020
A quick note on #orcldb hint usage reporting in Oracle Database 19c blogs.oracle.com/optimizer/h…

3
16
3 Mar 2020
Using lock table stats to make life easier blogs.oracle.com/optimizer/l…

4
20
VLDB Bayliss retweeted
The list of questions for the CBO panel at the UKOUG TechFest19 is slowly growing - but there's only a week left before the event starts and we could do with a few more questions: jonathanlewis.wordpress.com/… @SQLMaria @vldbb @ChrisAntognini @foote will be in the hot seats.

1
8
9
VLDB Bayliss retweeted
The CBO Panel Session for @UKOUG TechFest19 has been moved from Monday to Tuesday at 16:45. I'll be chairing it, with a terrific panel of experts - but we need a few more questions in advance: jonathanlewis.wordpress.com/…

3
3
9
15 Oct 2019
Resolving performance regressions with #oracle 18c and 19c SQL plan management blogs.oracle.com/optimizer/r…

2
12
26