October 2024 - Oracle 19C, 23ai Photo by Julius Drost on Unsplash So a while ago I spoke about passwords but forgot to mention a key element of account control in the blog. I was giving a talk on Security a few days ago and told an audience member that this information was in my…

Neil Chandler's DBA Blog

02.11.2024

Unlocking Insights: Why Conferences Matter – Neil Chandler's DB Blog

I very much enjoy speaking at conferences, and talking to everyone there. The insights that you get into how other companies are running their systems is incredible. The innovative approaches that different people and companies have to solving the same problems never ceases to amaze me, and the only way to really discover this. You…

Neil Chandler's DBA Blog

03.02.2025

Infinity – Old Oracle Numbers – Neil Chandler's DB Blog

A long time ago, Oracle had a couple of special numbers that you were allowed to store in a NUMBER datatype. They were Infinity and Negative Infinity! If you selected these numbers (using SQL*Plus) , they showed up as "~" and "-~", although it is worth noting that if you're using the funky modern sqlcl…

Neil Chandler's DBA Blog

12.06.2025

ORA-04021 timeout occurred while waiting to lock object during stats gather – Neil Chandler's DB Blog

I recently came across an interesting change in behaviour when gathering stats. Patch 32781163 (Deadlock on library cache lock on MV refresh and dbms_stats gathering the same object) was applied to an Oracle 19C system, and as well as curing the deadlock problem the client was experiencing it also changed one of the Global Stats…

home›Neil Chandler's DBA Blog

Neil Chandler's DBA Blog

Software

Fundamental Security Part Nine – Scripted Passwords – Neil Chandler's DB Blog

Unlocking Insights: Why Conferences Matter – Neil Chandler's DB Blog

Infinity – Old Oracle Numbers – Neil Chandler's DB Blog

ORA-04021 timeout occurred while waiting to lock object during stats gather – Neil Chandler's DB Blog

home
›
Neil Chandler's DBA Blog