50 years using computers, 40 years freelancing, 35 years dealing with Oracle design and performance issues; mostly retired. Now tweeting at jloracle.bsky.social
London, UK
- Tweets 14,888
- Following 38
- Followers 9,596
- Likes 1,515
Pinned Tweet
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/20181213…
4
1
20
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/…
1
6
425
Jonathan Lewis retweeted
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
ALT Astronaut Jim Lovell, wearing a white spacesuit with no helmet, stands outside with a tall rocket and launch tower behind his left shoulder. Lovell is pictured from the chest up; he is looking at the camera and smiling. Credit: NASA
3,111
16,558
90,223
12,563,348
Two months since the last blog note, I hope it's worth the wait:
jonathanlewis.wordpress.com/…
2
10
692
Jonathan Lewis retweeted
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...)
1
2
16
1,290
Jonathan Lewis retweeted
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-2025/
9
10
1,534
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/…
3
7
515
Jonathan Lewis retweeted
The days of running oradebug without restriction are numbered!
jonathanlewis.wordpress.com/…
1
1
3
460
I'll be speaking at #POUG2025 (Sept 5th/6th). poug2025.konfeo.com/en/group…
The abstract for my session is the sole entry under the "Public Appearances" page on my blog:
jonathanlewis.wordpress.com/…...
2
4
27
2,592
Jonathan Lewis retweeted
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/Residu…
3
10
47
3,631
Jonathan Lewis retweeted
Calling out delusional developers...
connor-mcdonald.com/2025/04/…
6
8
27
1,483
Jonathan Lewis retweeted
If your developers are talking about the database as «the Persistence Layer», you are in trouble 🥸
2
5
13
1,183
Jonathan Lewis retweeted
"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)
1
6
504
Jonathan Lewis retweeted
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!
piped.video/V5m4OTELby4
6
9
43
3,820
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/…
5
9
727
"Just the facts, ma'am"
wjtv.com/business/press-rele…
3
314
Jonathan Lewis retweeted
When Oracle Database Release Updates Attack
oracle-base.com/blog/2025/03…
1
4
27
1,019
Jonathan Lewis retweeted
The issue has been fixed with Patch 36791812: FDA DDLs Are Offline, Leading to Unusable FDA Indexes.
1
1
445
