© Mapbox, © OpenStreetMap

Speaker

Neil Chandler

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

  • Information & Communications Technology

Topics

  • Oracle
  • Oracle Database
  • Oracle Cloud Infrastructure
  • Oracle DBA
  • Oracle Dataguard
  • Oracle RAC
  • Databases

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.

September 2024 Stockholm, Sweden

MakeIT 2024 / JCON OpenBlend Slovenia 2024 Sessionize Event

May 2024 Portorož, Slovenia

ConTech2024 by RoOUG Sessionize Event

May 2024 Bucharest, Romania

OUGN 2024

Get Me Off That F*cking Exadata

April 2024 Oslo, Norway

Sym42 Meetup

March 2024 Porto, Portugal

SOUC 2024

Fundamental Oracle Security - what many of you are not doing
Get Me Off That F*cking Exadata

January 2024 Zürich, Switzerland

DOAG 2023

Get Me Off That F*cking Exadata

November 2023 Nürnberg, Germany

POUG 2023

Blockbuster: An Idiots Guide (to block internals)

November 2023 Warsaw, Poland

UKOUG 2023

Get Me Off That F*cking Exadata

November 2023 Reading, United Kingdom

MakeIT 2023

What the heck is the Oracle Optimizer up to? - Costing
What the heck is the Oracle Optimizer up to? - Transformations

June 2023 Portorož, Slovenia

DOAG Database + Exadata 2023

What the heck is the Oracle Optimizer up to? - Costing
What the heck is the Oracle Optimizer up to? - Transformations

May 2023 Düsseldorf, Germany

POUG Workshop 2023

Unified Audit - you're already using it. Use it better.
Get Me Off That F*cking Exadata

May 2023 Warsaw, Poland

OUGN 2023

Fundamental Oracle Security – What Many Of You Are Not Doing,
Statistics and the Optimizer. How Oracle Makes Decisions

April 2023 Oslo, Norway

UKOUG 2022

Fundamental Oracle Security – What Many Of You Are Not Doing,

December 2022 Birmingham, United Kingdom

DOAG 2022

How the Oracle Optimizer Makes Decisions
Fundamental Oracle Security – What Many Of You Are Not Doing,

September 2022 Nürnberg, Germany

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)

September 2022 Warsaw, Poland

OUG Ireland 2022

Fundamental Oracle Security – What Many Of You Are Not Doing,

September 2022 Dublin, Ireland

MakeIT 2022

Fundamental Oracle Security - what many of you are not doing

June 2022 Portorož, Slovenia

OUG Scotland

Fundamental Oracle Security - what many of you are not doing

April 2022 Glasgow, United Kingdom

AIOUG 2021

Step by Step to Public Speaking
Fireside chat with Database Performance Tuning Gurus

December 2021

Tivadis Performance Days 6

How the Oracle Optimizer Makes Decisions

October 2021 Zürich, Switzerland

POUG 2021

POUG Hugs and Whisky

September 2021 Warsaw, Poland

AIOUG Webiunar

What the heck is the Oracle Optimizer up to? - Costing

February 2021

AIOUG 2020

What the heck is the Oracle Optimizer up to? - Costing
What the heck is the Oracle Optimizer up to? - Transformations

January 2021

AIOUG Webinar

What the heck is the Oracle Optimizer up to? - Transformations

January 2021

UKOUG 2020

What the heck is the Oracle Optimizer up to? - Costing
What the heck is the Oracle Optimizer up to? - Transformations

December 2020

SPOUG 2020

Database Stats. Doing It Right, The Easy Way

October 2020 Madrid, Spain

OGBEMEA 2020

Database Stats. Doing It Right, The Easy Way
Database Stats. Doing It Right, When Its Harder

October 2020

POUG Workshop 2020

What the heck is the Oracle Optimizer up to?

July 2020

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

January 2020 Rome, Italy

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

January 2020 Milan, Italy

Sangam 2020

Database Stats. Doing It Right, The Easy Way
Database Stats. Doing It Right, When Its Harder

December 2019

UKOUG 2019

Database Stats. Doing It Right, The Easy Way
Database Stats. Doing It Right, When Its Harder

December 2019 Brighton, United Kingdom

DOAG 2019

Database Stats. Doing It Right, The Easy Way
Database Stats. Doing It Right, When Its Harder

November 2019 Nürnberg, Germany

BGOUG 2019

Histograms Are Evil Like Chocolate Is Evil
Using JSON in Oracle.

June 2019 Samokov, Bulgaria

UKOUG 2018

Using JSON in Oracle.

December 2018 Birmingham, United Kingdom

Oracle OpenWorld

REST Enabled Neural Networks

October 2018 San Francisco, California, United States

SPOUG 2018

Using JSON in Oracle.

September 2018 Madrid, Spain

POUG 2018

Using JSON in Oracle

September 2018 Sopot, Poland

Riga Dev Days

Top 7 Plan Stability Pitfalls And How To Avoid Them

May 2018 Riga, Latvia

OUGN 2018

DataGuard FarSync and FSFO
Histograms Are Evil Like Chocolate Is Evil

March 2018 Oslo, Norway

OUG Ireland 2018

Histograms Are Evil Like Chocolate Is Evil

February 2018 Dublin, Ireland

ILOUG 2018

Histograms Are Evil Like Chocolate Is Evil
Q&A Panel

January 2018 Tel Aviv, Israel

DOAG 2017

Histograms Are Evil Like Chocolate Is Evil

November 2017 Nürnberg, Germany

HrOUG 2017

Top 7 Plan Stability Pitfalls And How To Avoid Them
Histograms Are Evil Like Chocolate Is Evil

October 2017 Rovinj, Croatia

SiOUG 2017

Top 7 Plan Stability Pitfalls And How To Avoid Them
DataGuard FarSync and FCF
Histograms Are Evil Like Chocolate Is Evil

October 2017 Portorož, Slovenia

POUG 2017

Histograms Are Evil like Chocolate is Evil

September 2017 Kraków, Poland

ClubOracle

DataGuard FarSync and FCF

March 2017 London, United Kingdom

OUG Ireland 2017

Top 7 Plan Stability Pitfalls And How To Avoid Them

March 2017 Dublin, Ireland

POUG Meetup 2017

Troubleshooting Goldengate

February 2017 Warsaw, Poland

UKOUG Tech 16

An Introduction to RAC, Troubleshooting Goldengate, Trace File Analyzer (TFA)
DataGuard FarSync and FCF

December 2016 Birmingham, United Kingdom

DOAG 2016

Top 7 Plan Stability Pitfalls And How To Avoid Them

November 2016 Nürnberg, Germany

POUG 2016

Top 7 plan stability pitfalls and how to avoid them

October 2016 Warsaw, Poland

BGOUG 2016

Top 7 Plan Stability Pitfalls And How To Avoid Them
DataGuard FarSync and FCF

June 2016 Pravets, Bulgaria

OUG Ireland 2016

An Introduction to RAC

March 2016

Oracle Midlands

SPM - Why my plan changed.

November 2015 Birmingham, United Kingdom

UKOUG RAC SIG

Introduction to RAC

July 2015 Reading, United Kingdom

UKOUG Tech14

Introducing Goldengate

December 2014 Liverpool, United Kingdom

UKOUG Tech13

10046 -- pointless or powerful in the real world
SPM - Why has my plan changed.

December 2013 Manchester, United Kingdom

UKOUG M&I SIG

10046 -- pointless or powerful in the real world

May 2011 London, United Kingdom

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