Neil Chandler
Oracle Database Expert
London, United Kingdom
Actions
Neil has been working in IT since 1988 when he coded Assembler and Cobol on IBM Mainframes against both hierarchical (NoSQL-ish) and relational databases. He started using Oracle software in 1991. Neil is an Oracle ACE Director and a founding member of the MASH Program. He likes to drink strong smooth Italian coffee, good beer and better whisky, depending upon the time of day.
Awards
Area of Expertise
Topics
Oracle Transactions - more than meets the eye
insert, update, write to disk, commit. That’s it, right? Well, yes and no. Well, no. Oracle is complex (you might have noticed) and it has a lot of mechanisms to ensure data integrity when you make changes. I hope I can explain what’s going on, so you can understand just how much work Oracle is doing to ensure the data you are reading and writing is correct, and showing how Oracle avoids doing work unless it really has to. I’m sorry, but this will involve showing you some block internals.
Blockbuster! A simple guide to Oracle block internals, and hacking them!
Do you understand how an Oracle block is put together? The more you understand about how the database works, the better you will be able to do your job. What if you have a major problem with your database and there’s a block-level problem - maybe something is corrupt. What can you do? What if you need to manually edit a block for other “reasons”, or you just want to understand the block structure a bit better. Come have a discussion about it. Let see what we can do to fix such problems. Lets see how rico2 (or bbed) works and what you can and cannot easily change within a block.
Unified Audit - you're already using it. Use it better.
If you are on Oracle 12.1 or higher you are using Unified Audit unless you ahve explicitly disabled it. Which is a very good idea on 12.1. However, you could be using it so much better. If you aren't auditing what's going on in your database, how would you know if you have a data breach, who did it and how. Potentially even what was stolen. You might also be suffering unexpected performance issues in relation to the Unified Audit, and not just in the broken 12.1 implementation of it! It just might not have materialised yet.
Fundamental Oracle Security – What Many Of You Are Not Doing
I tend to work in a few companies each year. Something I have been getting asked more and more, other than “make it faster”, it how to secure the Oracle database – frequently because of a failed audit. In companies and governments, I see; poor auditing, no security consideration, no lockdown of accounts, inadequate processes, and lots of risk. There are some easy and straightforward changes which you can make to your Oracle database which will make it more secure, harder to exploit and, in the unfortunate even of a data breach, give you a chance of noticing what happened! I will talk through the changes you can make and explain why they should be made, and the effort involved.
Get me off that F*cking Exadata!
Exadatas are amazing machines. They have some extraordinary capabilities. And they are quite expensive. I mean, really quite expensive. And we need to re-buy them every few years as they age.
A client came along one day and asked me "what can we do to cut the bills?"
I said "Nothing. Pay the money."
And they said "We don't want to! Can't we do something cheaper?".
"erm"
"Look, can you get us off those f*cking Exadata machines?"
This is a short story explaining if I could.
SweOUG Meetup
Unified Audit - you're already using it. Use it better.
MakeIT 2024 / JCON OpenBlend Slovenia 2024 Sessionize Event
ConTech2024 by RoOUG Sessionize Event
OUGN 2024
Get Me Off That F*cking Exadata
SOUC 2024
Fundamental Oracle Security - what many of you are not doing
Get Me Off That F*cking Exadata
DOAG 2023
Get Me Off That F*cking Exadata
POUG 2023
Blockbuster: An Idiots Guide (to block internals)
UKOUG 2023
Get Me Off That F*cking Exadata
MakeIT 2023
What the heck is the Oracle Optimizer up to? - Costing
What the heck is the Oracle Optimizer up to? - Transformations
DOAG Database + Exadata 2023
What the heck is the Oracle Optimizer up to? - Costing
What the heck is the Oracle Optimizer up to? - Transformations
POUG Workshop 2023
Unified Audit - you're already using it. Use it better.
Get Me Off That F*cking Exadata
OUGN 2023
Fundamental Oracle Security – What Many Of You Are Not Doing,
Statistics and the Optimizer. How Oracle Makes Decisions
UKOUG 2022
Fundamental Oracle Security – What Many Of You Are Not Doing,
DOAG 2022
How the Oracle Optimizer Makes Decisions
Fundamental Oracle Security – What Many Of You Are Not Doing,
POUG 2022
Fundamental Oracle Security – What Many Of You Are Not Doing,
Performance Tuning with FRIENDS (co-present)
Planning my Summer Vacation using Python and Machine Learning (co-present)
OUG Ireland 2022
Fundamental Oracle Security – What Many Of You Are Not Doing,
MakeIT 2022
Fundamental Oracle Security - what many of you are not doing
OUG Scotland
Fundamental Oracle Security - what many of you are not doing
AIOUG 2021
Step by Step to Public Speaking
Fireside chat with Database Performance Tuning Gurus
Tivadis Performance Days 6
How the Oracle Optimizer Makes Decisions
POUG 2021
POUG Hugs and Whisky
AIOUG Webiunar
What the heck is the Oracle Optimizer up to? - Costing
AIOUG 2020
What the heck is the Oracle Optimizer up to? - Costing
What the heck is the Oracle Optimizer up to? - Transformations
AIOUG Webinar
What the heck is the Oracle Optimizer up to? - Transformations
UKOUG 2020
What the heck is the Oracle Optimizer up to? - Costing
What the heck is the Oracle Optimizer up to? - Transformations
SPOUG 2020
Database Stats. Doing It Right, The Easy Way
OGBEMEA 2020
Database Stats. Doing It Right, The Easy Way
Database Stats. Doing It Right, When Its Harder
POUG Workshop 2020
What the heck is the Oracle Optimizer up to?
ITOUG 2020 Rome
Histograms are Evil like Chocolate is Evil
Database Stats. Doing It Right, The Easy Way
Database Stats. Doing It Right, When Its Harder
ITOUG 2020 Milan
Histograms are Evil like Chocolate is Evil
Database Stats. Doing It Right, The Easy Way
Database Stats. Doing It Right, When Its Harder
Sangam 2020
Database Stats. Doing It Right, The Easy Way
Database Stats. Doing It Right, When Its Harder
UKOUG 2019
Database Stats. Doing It Right, The Easy Way
Database Stats. Doing It Right, When Its Harder
DOAG 2019
Database Stats. Doing It Right, The Easy Way
Database Stats. Doing It Right, When Its Harder
BGOUG 2019
Histograms Are Evil Like Chocolate Is Evil
Using JSON in Oracle.
UKOUG 2018
Using JSON in Oracle.
Oracle OpenWorld
REST Enabled Neural Networks
SPOUG 2018
Using JSON in Oracle.
POUG 2018
Using JSON in Oracle
Riga Dev Days
Top 7 Plan Stability Pitfalls And How To Avoid Them
OUGN 2018
DataGuard FarSync and FSFO
Histograms Are Evil Like Chocolate Is Evil
OUG Ireland 2018
Histograms Are Evil Like Chocolate Is Evil
ILOUG 2018
Histograms Are Evil Like Chocolate Is Evil
Q&A Panel
DOAG 2017
Histograms Are Evil Like Chocolate Is Evil
HrOUG 2017
Top 7 Plan Stability Pitfalls And How To Avoid Them
Histograms Are Evil Like Chocolate Is Evil
SiOUG 2017
Top 7 Plan Stability Pitfalls And How To Avoid Them
DataGuard FarSync and FCF
Histograms Are Evil Like Chocolate Is Evil
POUG 2017
Histograms Are Evil like Chocolate is Evil
ClubOracle
DataGuard FarSync and FCF
OUG Ireland 2017
Top 7 Plan Stability Pitfalls And How To Avoid Them
POUG Meetup 2017
Troubleshooting Goldengate
UKOUG Tech 16
An Introduction to RAC, Troubleshooting Goldengate, Trace File Analyzer (TFA)
DataGuard FarSync and FCF
DOAG 2016
Top 7 Plan Stability Pitfalls And How To Avoid Them
POUG 2016
Top 7 plan stability pitfalls and how to avoid them
BGOUG 2016
Top 7 Plan Stability Pitfalls And How To Avoid Them
DataGuard FarSync and FCF
OUG Ireland 2016
An Introduction to RAC
Oracle Midlands
SPM - Why my plan changed.
UKOUG RAC SIG
Introduction to RAC
UKOUG Tech14
Introducing Goldengate
UKOUG Tech13
10046 -- pointless or powerful in the real world
SPM - Why has my plan changed.
UKOUG M&I SIG
10046 -- pointless or powerful in the real world
Neil Chandler
Oracle Database Expert
London, United Kingdom
Actions
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top