Contenting Logo

News

Entertainment

Science & Technology

Sport

Business & Money

Life

Culture & Art

Hobbies

Sites
Lists
#tags
  1. home
    2. ›
  2. Neil Chandler's DBA Blog

Neil Chandler's DBA Blog

8 | Follower

Software

See All

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…

Neil Chandler's DBA Blog

08.08.2025

Oracle Database: Global Stats Changes After Partition Truncate – Neil Chandler's DB Blog

I may be late to the party on this one, but it certainly surprised me during a database migration from Oracle 11G to Oracle 19.26 recently (yes, there's a surprising amount of databases still on 11G - released in 12 years ago, and 10G, and even 9i, 8i, 8.0 and even 7.2). We were experiencing…

Contenting Logo
About UsPrivacy PolicyTerms Of UseContact