VLDB Bayliss
@vldbb
Followers
1K
Following
298
Media
5
Statuses
247
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
Joined May 2014
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 for a new ADB demo.
blogs.oracle.com
Real-time SQL plan management (SPM) is available in Oracle Database 23ai and Oracle Autonomous Database 19c.
0
8
18
If you use the optimizer_secure_view_merging DB parameter, check out the change in Oracle Database 23ai
blogs.oracle.com
The database parameter optimizer_secure_view_merging has been depricated. Use the "merge any view" privilege instead.
0
9
13
The new SQL analysis report in Oracle Database 23c Free
blogs.oracle.com
There's a useful new optimizer feature for developers in Oracle Database 23c Free.
2
15
42
RT @ChrisAntognini: ANNOUNCING #tvdpdays 2022. The hybrid event is scheduled on September 28/29. This year’s speakers are @vldbb @JLOracle….
accenture.com
Across industries and around the world, we’re creating better experiences for people using emerging technologies and human ingenuity. Together, we can reinvent anything.
0
14
0
RT @SQLMaria: It's Follow Friday, so here are some awesome @OracleDatabase Product Managers you should be following.@thatjeffsmith @vldbb @….
0
10
0
RT @thatjeffsmith: Follow Friday - some core @OracleDatabase Product Managers. @yasinbaskan @dohdatabase @KnownAsMarkus @SQLMaria @GeraldV….
0
13
0
Improving cardinality estimates with dynamic statistics
blogs.oracle.com
Cardinality misestimates can lead to sub-optimal SQL execution plans. Dynamic sampling can help.
0
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
Introduction This is a follow-on from a previous blog about plan stability. It is worth looking at this first if you haven't already. This blog post proposes that if you have a SQL performance issue,...
0
3
12
I am going to write a short series of posts on improving cardinality estimates. This is the intro
blogs.oracle.com
Execution Plan Changes I am often asked: Why do my SQL execution plans keep changing, and why are they sometimes so bad? Is there a bug? I have upgraded a database, but some SQL statements perform...
2
8
30
Some information on the Automatic SQL Tuning Set
blogs.oracle.com
Oracle Database 19c Release Update 19.7 exposed a new database infrastructure component called the automatic SQL Tuning Set (ASTS). It was on by default in this Release Update (RU) but Oracle has...
1
12
30
A quick note on #orcldb hint usage reporting in Oracle Database 19c
blogs.oracle.com
I mentioned in an earlier blog post that in Oracle Database 19c we introduced a hint usage report for DBMS_XPLAN. If you have been using this feature then you might have noticed that some hints are...
0
3
16
RT @MDWidlake: Things I never expected to do #14:. Announce the cancellation of an event due to a worldwide pandemic. OK, it's not a pande….
0
4
0
Resolving performance regressions with #oracle 18c and 19c SQL plan management
blogs.oracle.com
You were hoping for an uneventful day at work when you notice that you have a critical workload query that is taking much longer to execute than usual, and you can see that it is beginning to affect...
2
12
26
RT @amitzil: Summary of the sessions I attended at #OOW19./cc @brendantierney @richardfoote @vanpupi @OracleRACpm @….
gotodba.com
This year I added quite a few sessions to my OOW19 schedule, and I managed to go to most of them (and 1 that I wasn’t planning to go initially). As I mentioned in my OOW wrap-up post, the summary of...
0
9
0