iiinova — where your digital self keeps evolving

Reposted by Neil Chandler

SQLDaily @sqldaily.bsky.social · 16/09/2026

There are many ways you can define STATUS columns in Oracle SQL e.g. mark a row COMPLETE you could store a Descriptive string Single character Numeric value NULL value Boolean flag @chandlerdba.bsky.social covers storage and performance considerations for each buff.ly/a4ZjsqH

buff.ly

“Status” columns in Oracle

What’s the best way to represent status/flag low cardinality columns in Oracle

021

Neil Chandler @chandlerdba.bsky.social · 15/09/2026

Oh! I'm off to HrOUG in Croatia again. #oracle Time to learn and network on a beautiful island in the Adriatic Sea. How do I cope with such hardshiips? You too could suffer being marooned on an island for a couple of days just learning and relaxing: 2026.hroug.hr/eng/ @oracleace.bsky.social

Banner advertising 2 tech talks at Hroug, the croatian oracle user group. Dissecting Performance Tuning and Hacking Oracle Blocks. By Neil Chandler. Oracle ACE Director and stuff.

040

Neil Chandler @chandlerdba.bsky.social · 12/09/2026

I'll be speaking at UKOUG in November. I would be great to see you there.

I'll be speaking at UKOUG in November: Dissecting Performance Tuning

101

Reposted by Neil Chandler

Martin Berger (berx) @martinberx.bsky.social · 05/09/2026

@chandlerdba.bsky.social rants about what's going really on in performance tuning engagements #POUG2026

052

Reposted by Neil Chandler

Erik van Roon @evrocs.bsky.social · 05/09/2026

Standing room for @chandlerdba.bsky.social session at #poug2026

091

Reposted by Neil Chandler

Dani Schnider @danischnider.bsky.social · 05/09/2026

Crowded rom for @chandlerdba.bsky.social‘s session „Dissecting Performance Tuning“

071

Reposted by Neil Chandler

Johannes Ahrends @carajan.bsky.social · 04/09/2026

#POUG2026 An event with top-tier international speakers is taking place Sept. 4–5 in Kraków. Among the speakers are Jonathan Lewis, Neil Chandler, Dani Schnieder, and Christian Antonini. #ora2know is part of it: Robert Marz, Martin Klier, and I get to "step into the ring" in this top-tier lineup.

062

Reposted by Neil Chandler

SQLDaily @sqldaily.bsky.social · 03/09/2026

Want a detailed visual report of Oracle Database activity? That you can save locally for later reference or sharing? @chandlerdba.bsky.social shows how you can do it by calling DBMS_PERF.REPORT_PERFHUB Note: it requires and Oracle Diagnostics Pack license to run buff.ly/h9dEueL

buff.ly

Performance Report – REPORT_PERFHUB

Generating a little used but amazing performance report from Oracle…

031

Neil Chandler @chandlerdba.bsky.social · 15/08/2026

#SAFC preseason ends with a 2-1 comfortable victory over fellow Europa league team Stade Rennais. Good goals by Brobbey and Hume, with next to nothing for Roefs to do all game. Fairly even 1st half, and a much more dominant 2nd as we stepped up the urgency to come back from 1-0 down. #HAWAY!

120

Neil Chandler @chandlerdba.bsky.social · 15/08/2026

#safc 2-1 to Sunderland. Free kick from LeFee, a little pinball in the box and Hume rolls it home into the bottom left corner.

030

Reposted by Neil Chandler

Fabrizio Romano (MIRROR) @fabrizioromano.yopro20.com · 15/08/2026

🚨🔴⚪️ Dayann Méthalie to Sunderland, here we go! Verbal agreement in place for the left back at €28m plus €2m add-ons. #SAFC have scheduled travel and medical for the fullback to join in the next days after Toulouse accepted their last proposal.

092

Neil Chandler @chandlerdba.bsky.social · 15/08/2026

#safc nice strength by Brobbey to level the score 1-1, chasing onto a poor back header then shouldering the defender off the ball.

020

Neil Chandler @chandlerdba.bsky.social · 15/08/2026

#SAFC friendly against Stade Rennais. Pretty even first half, Stade leading 1-0 through a well taken penalty given away softly by Ballard. SR look good on the break, and we’ve had some decent half chances and a good save from a shot by Reinildo.

020

Neil Chandler @chandlerdba.bsky.social · 12/08/2026

Well that was fun. Amazing partial #eclipse shadows cast by trees, too

Partial eclipse shot through filter on iPhone.

Crescent shaped shadows on a a door, cast by nearby trees

130

Reposted by Neil Chandler

Count Binface @countbinface.bsky.social · 09/08/2026

Wow. Just wow.

11669231653

Reposted by Neil Chandler

Doug Burns @orcldoug.bsky.social · 09/08/2026

Domain gone, database gone, files gone — but the Wayback Machine had it all. I've (actually Claude) rebuilt oracledoug.com from the archive, post by post. Back at orcldoug.com: 700+ Oracle posts & comments, the old white papers, and my '80s Speccy games playable in-browser. 🕹️ orcldoug.com

orcldoug.com

Home - Doug Burns Oracle Resources

Welcome to oracledoug.com The primary purpose of this site was always to distribute various Oracle-related papers I’ve written and presented at User Group conferences over the years. Alongside those y...

2103

Neil Chandler @chandlerdba.bsky.social · 06/08/2026

Running Oracle and you need a performance report? Do you use REPORT_PERFHUB? WHY NOT! It really is a wonderful addition to the DBA's toolbox. Check out how to create it here, including a link to clickable "test" report I did so you can see how useful it really is chandlerdba.com/2026/08/05/p...

chandlerdba.com

Performance Report – REPORT_PERFHUB

Generating a little used but amazing performance report from Oracle…

020

Reposted by Neil Chandler

Andrew (Arfur) Clarke @apcrft.bsky.social · 04/08/2026

Yeah it's a shame they couldn't be arsed to credit the creator, @christhebarker.bsky.social bsky.app/profile/b3ta...

131

Reposted by Neil Chandler

Angry People in Local Newspapers @apiln.bsky.social · 30/07/2026

“Have you checked the copy for the Enterprise display ad?” “Didn’t need to, it’s the same every week” [one day later] “Oh”

Display ad for Enterprise car rentals, offering cock-sucking because someone was having bants in the production system.

38673204

Reposted by Neil Chandler

Top Flight Time Machine @tftimemachine.bsky.social · 27/07/2026

Some very sad news - Zippy is and will always be a Person Of Interest on our podcast. You might find yourself wondering about Zippy's whereabouts these days... well... 1/3

24516

Reposted by Neil Chandler

Count Binface @countbinface.bsky.social · 07/07/2026

On my way, Clacton.

579152853460

Reposted by Neil Chandler

Jaunty Art @jaunty.art · 25/06/2026

A story about the 21st birthday gift I got my eldest daughter (in the alt text).

I took my eldest daughter fossil hunting on the north east Scottish coast when she was 9 and we found a few good ones.

I’d kept them in a box in the garage all these years and fished them out last month and took a hammer to the rocks to see if there were any good samples

There were some great ones and I got one of the ammonite fossils she found mounted in silver by a local jeweller Sparkle By Faith and gave it her as a 21st birthday gift.

She’s very boho chic so the design and style of it fits very well with her aesthetic.

16799

Reposted by Neil Chandler

SQLDaily @sqldaily.bsky.social · 27/05/2026

The clustering factor in Oracle Database measures The similarity in the orders of Logical index values Physical table row locations Lower value => closer match => the index is more effective @chandlerdba.bsky.social explains & suggests ways to improve it

buff.ly

Performance: Index Clustering Factor

Understanding TABLE_CACHED_BLOCKS

031

Reposted by Neil Chandler

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · 26/05/2026

My first visit to Slovenia, I'm excited to be a speaker at SIOUG MakeIT 2026! I'm on twice tomorrow: - Visualizing PL/SQL with PL/Scope, 26ai Property Graph and APEX Graph Plug-in - 3-hour Hands-On-Lab on analytic functions. Check it out: makeit.si #MakeIT2026 #OracleDB #OracleAPEX #OracleACE

094

Reposted by Neil Chandler

Øyvind Isene @oyvindisene.bsky.social · 26/05/2026

First time for me at the wonderful Make IT Conference! One session on Thursday and one on Friday. Looking forward to this a lot. #OracleACE #MakeIT2026

0104

Reposted by Neil Chandler

Connor McDonald on Database and SQL @connormcd.bsky.social · 26/05/2026

30 seconds to convince you to put APEX Connect on your calendar for next year! Community FTW

041

Reposted by Neil Chandler

Mark @vbloke.com · 26/05/2026

There is a quote from a fantastic 1950’s B movie “It Came from Outer Space”, part written by the legendary Ray Bradbury, that has stuck with me since I first saw it as a child:

111

Neil Chandler @chandlerdba.bsky.social · 25/05/2026

Woke up still in disbelief after a 900km round trip to see #SAFC qualify for Europa League - back in Europe after 53 years. ❤️🤍❤️🤍❤️ HAWAY THE LADS!

SAFC team and staff photo in front of the Roker end

1150

Reposted by Neil Chandler

Oracle ACE Program @oracleace.bsky.social · 20/05/2026

🍽️✨ Another fantastic evening with the Oracle ACE community — this time at Bulls & Bandits in Heide Park Resort, Soltau! Do you want to be part of this amazing community? 🙌 Then submit your registration or nomination here: 🔗 ace.oracle.com/ords/r/ace/o... #OracleACE

063

Reposted by Neil Chandler

Oracle ACE Program @oracleace.bsky.social · 20/05/2026

🎢✨ What an amazing afternoon with the Oracle ACE community at Heide Park Resort in Soltau! From thrilling roller coasters 🎠 to great conversations and lots of laughter, this was the perfect mix of fun & networking 🚀 Want to be part of this amazing community? 🙌 🔗 ace.oracle.com/ords/r/ace/o...

052

Reposted by Neil Chandler

Sascha Schäfer @saschaschaefer.eu · 18/05/2026

@chandlerdba.bsky.social on "Troubleshooting Oracle Memory" #DOAGDB26

021

Reposted by Neil Chandler

Niels de Bruijn @nielsdb.bsky.social · 18/05/2026

Packed room for Connor! #orclapex #apexconn26

063

Reposted by Neil Chandler

Kevin Parry @kevinbparry.bsky.social · 15/05/2026

Testing a new mirror trick

301171262

Reposted by Neil Chandler

DOAG e.V. @doagev.bsky.social · 13/05/2026

#DOAGDB26 | Die Vorfreude steigt – in knapp 4 Tagen beginnt die DOAG 2026 Datenbank mit Cloud Infrastructure im Heide Park Soltau. Wir haben die FAQs rund um die Konferenz am 18. und 19. Mai um viele spannende Punkte bereichert. Please check ✅ 👍 😃 datenbank.doag.org/de/faqs/ #Datenbank

053

Reposted by Neil Chandler

Angri Bundel @anibundel.com · 11/05/2026

We lost Douglas Adams 25 years ago today. This has made a lot of people very sad and has been widely regarded as a bad move.

136110432907

Neil Chandler @chandlerdba.bsky.social · 08/05/2026

Maybe just adjusting statistics to use indexes just isn't enough. For huge performance gains, you might want to consider clustering the actual data (if you can). Have another blog post. chandlerdba.com/2026/05/08/p...

chandlerdba.com

Performance: Clustering Data

In my previous post I spoke about using TABLE_CACHED_BLOCKS to make the CLUSTERING_FACTOR for indexes more realistic by having Oracle assume there was more than 1 block from the table in the buffer…

001

Neil Chandler @chandlerdba.bsky.social · 06/05/2026

I recently wrote a block post, which was popular. So here's another one. A bit about performance and using indexes this time. Well, really it's about setting TABLE_CACHED_BLOCKS, given that most of you kids out there still don't. Understand what it means, and set it! chandlerdba.com/2026/05/06/p...

chandlerdba.com

Performance: Index Clustering Factor

Understanding TABLE_CACHED_BLOCKS

262

Neil Chandler @chandlerdba.bsky.social · 30/04/2026

@markthomasinfo.bsky.social argh! I now have to get up at 4am tomorrow to try to secure tickets for your show in London on Remembrance Sunday. I am NOT a mornings person.

000

Reposted by Neil Chandler

Sylvia @sylvia-suffragette.bsky.social · 23/04/2026

@patrick-barlow.bsky.social 🤔 They arrested the same woman, who 2 years ago took them to court for her arrest of holding the same sign; where the judge ruled it is not illegal to hold this sign

77856

Reposted by Neil Chandler

Ronnie Barbour @ronniebarbour.bsky.social · 22/04/2026

I'm happy report I am the new manager of Chelsea.

112

Reposted by Neil Chandler

Verified Bluesky @verifiedbsky.net · 22/04/2026

I've decided to shut down verifiedbsky.net. While there was quite a bit of interest early, that has basically completely died down and it took some effort to keep the service alive. It was fun, I learned a lot, but it doesn't make sense anymore. Thanks to everyone who used and supported it!

verifiedbsky.net

Bluesky verification

142

Reposted by Neil Chandler

DOAG e.V. @doagev.bsky.social · 21/04/2026

#DOAG2026: Der Call for Papers für die DOAG 2026 Konferenz + Ausstellung ist eröffnet! Bis zum 8. Juni habt ihr jetzt die Gelegenheit, eure Beiträge einzureichen.➡️ scomp.ly/3jJdQBr Konferenz: scomp.ly/xqV9Jp8 🔗Early-Bird-Tickets bis 29. September: scomp.ly/v0xlWdZ

065

Reposted by Neil Chandler

Christoph Lutz @christophlutz.bsky.social · 20/04/2026

1/2 Interesting and undocumented changes in SGA management in Oracle 26ai: - Up to 31 subpools in the shared pool (max seven in 19c defined by _kghdsidx_count) - Subpools are split into thee durations (there were only two in 19c)

162

Reposted by Neil Chandler

DOAG e.V. @doagev.bsky.social · 08/04/2026

#DOAGDB26: In seiner Session "Mission Impossible? Eine komplexe Exadata-Migration sicher in die Google Cloud" zeigt Amin Farvardin diese anhand eines realen Projekts. ➡️ scomp.ly/YWL3JrA Konferenz: datenbank.doag.org/de/home/ Tickets: scomp.ly/nZwDB5m #Datenbank #CloudInfrastructure

023

Reposted by Neil Chandler

rmoff 🏃‍♂️🫖🥓 @rmoff.net · 06/04/2026

Alex Woods - Don't Let AI Write For You alexhwoods.com/dont-let-ai-...

alexhwoods.com

Don't Let AI Write For You

2026.03

043