JLOracle's profile picture. 50 years using computers, 40 years freelancing, 35 years dealing with Oracle design and performance issues; mostly retired.
Now tweeting at http://jloracle.bsky.social

Jonathan Lewis

@JLOracle

50 years using computers, 40 years freelancing, 35 years dealing with Oracle design and performance issues; mostly retired. Now tweeting at http://jloracle.bsky.social

Pinned

The demon subdomain, including my old website disappeared a while ago, but there is a copy from December 2018 on the Wayback machine starting at: web.archive.org/web/2018121305…


Jonathan Lewis reposted

I'll be speaking at #UKOUGDiscover2025 ukoug.org/page/UKOUGDisc… about how transactions in Oracle really work. The agenda is up and online, and most excellent sessionize.com/api/v2/kspp9mk… Hope I'll see you in Birmingham on 30th November! #UKOUG25

ChandlerDBA's tweet image. I'll be speaking at #UKOUGDiscover2025 ukoug.org/page/UKOUGDisc… about how transactions in Oracle really work.  

The agenda is up and online, and most excellent sessionize.com/api/v2/kspp9mk… 

 Hope I'll see you in Birmingham on 30th November! #UKOUG25

I'm on the agenda for the #ukoug conference 2025. 9:00 a.m. on Monday morning (I tell myself that that's to encourage people to be on-site early enough to attend the opening keynote afterwards) jonathanlewis.wordpress.com/public-appeara…


Jonathan Lewis reposted

We are saddened by the passing of Jim Lovell, commander of Apollo 13 and a four-time spaceflight veteran. Lovell's life and work inspired millions. His courage under pressure helped forge our path to the Moon and beyond—a journey that continues today. go.nasa.gov/41tbrpq

NASA's tweet image. We are saddened by the passing of Jim Lovell, commander of Apollo 13 and a four-time spaceflight veteran.

Lovell's life and work inspired millions. His courage under pressure helped forge our path to the Moon and beyond—a journey that continues today. go.nasa.gov/41tbrpq

Two months since the last blog note, I hope it's worth the wait: jonathanlewis.wordpress.com/2025/05/27/pag…


Jonathan Lewis reposted

I think the more practical question (for now) is if a senior dev would end up producing junior level code when using AI agents? (... having distractions and deadlines, etc...)


Jonathan Lewis reposted

More than 3 months to #POUG2025 and we have 30 tickets left. Do you really want to miss over 40 tech sessions (no marketing! no sales pitches!) & opportunity to meet #Oracle stars like @connor_mc_d @JLOracle or @KerryOracleGuy ? Buy now or cry later: poug.org/edycja/poug-20…

POUG_ORG's tweet image. More than 3 months to #POUG2025 and we have 30 tickets left. Do you really want to miss over 40 tech sessions (no marketing! no sales pitches!) & opportunity to meet #Oracle stars like @connor_mc_d  @JLOracle  or @KerryOracleGuy ?
Buy now or cry later:
poug.org/edycja/poug-20…

I've just come across a blog note I wrote a few years ago about unexpected (and unreliable) results from v$undostat when it reports the "maxquerylen / id"; it's probably worth knowing about it: jonathanlewis.wordpress.com/2020/02/04/max…


Jonathan Lewis reposted

The days of running oradebug without restriction are numbered! jonathanlewis.wordpress.com/2024/03/12/dis…

ExaGridDba's tweet image. The days of running oradebug without restriction are numbered! 
jonathanlewis.wordpress.com/2024/03/12/dis…

I'll be speaking at #POUG2025 (Sept 5th/6th). poug2025.konfeo.com/en/groups The abstract for my session is the sole entry under the "Public Appearances" page on my blog: jonathanlewis.wordpress.com/public-appea...


Jonathan Lewis reposted

The old mathematical ones are the best. Maybe jokes are like mathematics. You either get them or you don't. But if you need a clue for Vishal's joke, this might help: en.wikipedia.org/wiki/Residue_t…


Jonathan Lewis reposted

In case anyone in the US wonders why Australians live approximately 7 years longer on average than Americans… 🤷‍♂️ 🇦🇺 #TrumpTariffs

richardfoote's tweet image. In case anyone in the US wonders why Australians live approximately 7 years longer on average than Americans… 🤷‍♂️ 🇦🇺 #TrumpTariffs

Jonathan Lewis reposted

If your developers are talking about the database as «the Persistence Layer», you are in trouble 🥸


Jonathan Lewis reposted

"If you trust in yourself and believe in your dreams and follow your star you'll still get beaten by people who spent their time working hard and learning things and weren't so lazy." Miss Tick (The Wee Free Men, Terry Pratchett)


Jonathan Lewis reposted

The database can now directly track all of the SQL statements you ran in a session, and keep a plethora of metadata and execution statistics about them as well! youtu.be/V5m4OTELby4

connor_mc_d's tweet card. Keep track of all of your SQL statements

youtube.com

YouTube

Keep track of all of your SQL statements


I've just spent a silly amount of time updating the catalogue pages on my blog with references to the last 27 (!) items I've published: jonathanlewis.wordpress.com/2022/01/25/cat…


Jonathan Lewis reposted

When Oracle Database Release Updates Attack oracle-base.com/blog/2025/03/1…

oraclebase's tweet image. When Oracle Database Release Updates Attack

oracle-base.com/blog/2025/03/1…

Jonathan Lewis reposted

The issue has been fixed with Patch 36791812: FDA DDLs Are Offline, Leading to Unusable FDA Indexes.


Loading...

Something went wrong.


Something went wrong.