@vldbb

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.

 London, England
blogs.oracle.com/optimizer
Joined May 2014
  • Tweets252
  • Following67
  • Followers1.3K
5Media
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
700
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,106
A new DBMS_SPM function is now available in #Oracle #Database #19c blogs.oracle.com/optimizer/p…
3
13
1
44
6,326
Automatic SPM is now available in #Oracle #Database #19c RU 19.22 EE blogs.oracle.com/optimizer/p…
17
1
30
3,974
The new SQL analysis report in Oracle Database 23c Free blogs.oracle.com/optimizer/p…
2
15
3
41
7,375
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
3
26
VLDB Bayliss retweeted
Maria Colgan@SQLMaria24 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
1
38
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
2
32
Improving cardinality estimates with dynamic statistics blogs.oracle.com/optimizer/c…

Improving Cardinality Estimates with Dynamic Statistics

Cardinality misestimates can lead to sub-optimal SQL execution plans. Dynamic sampling can help.

blogs.oracle.com
4
13
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
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
Some information on the Automatic SQL Tuning Set blogs.oracle.com/optimizer/t…
1
12
2
30
A quick note on #orcldb hint usage reporting in Oracle Database 19c blogs.oracle.com/optimizer/h…
3
16
Using lock table stats to make life easier blogs.oracle.com/optimizer/l…
4
1
20
VLDB Bayliss retweeted
Jonathan Lewis@JLOracle24 Nov 2019
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
Jonathan Lewis@JLOracle13 Nov 2019
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
Resolving performance regressions with #oracle 18c and 19c SQL plan management blogs.oracle.com/optimizer/r…
2
12
26
VLDB Bayliss retweeted
Liron Amitzi@amitzil26 Sep 2019
Summary of the sessions I attended at #OOW19 gotodba.com/2019/09/26/oracl… /cc @brendantierney @richardfoote @vanpupi @OracleRACpm @vldbb @MikeDietrichDE @RACMasterPM @FranckPachot @fritshoogland
9
1
18
Load more