@JLOracle

50 years using computers, 40 years freelancing, 35 years dealing with Oracle design and performance issues; mostly retired. Now tweeting at https://xitter.cf/t.co/jgM903GCKq

 London, UK
jonathanlewis.wordpress.com
Joined July 2013
  • Tweets14.9K
  • Following38
  • Followers9.6K
389Media
Include

Only show posts containing:

Exclude

Hide posts containing:

Time range
-
Minimum likes
Jonathan Lewis retweeted
Oxford Mathematics@OxUniMathsFeb 5
No words required.
11
42
3,154
Replying to @tmmdv
But some people prefer to travel by train ;)
1
2
152
Replying to @connor_mc_d
Are booleans in the database really useful? 😉
68%Yes
18%No
14%Other
28 votes • Final results
1
1
216
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 Appearances

Nov 30th / Dec 2nd   Birmingham, UK I’ll be delivering the following presentation on the Monday of  UKOUG Discover 2025 at 9:00 am: Predictions, Plans and Problems. Interpreting a single…

jonathanlewis.wordpress.com
1
6
434
Replying to @orcldoug
I'm sure that wasn't the way that Pavlov set up the experiment.
1
1
144
Replying to @NSFVoyager2 @xipteras
Another view of your launch: youtu.be/cCJh5D0FCZk

James Burke - perfectly-timed rocket launch 8/20/1977

Excerpt from the end of Connections, Episode 8: Eat, Drink and Be M...

youtube.com
2
9
863
Jonathan Lewis retweeted
NASA
@NASA8 Aug 2025
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
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

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,104
16,516
3,118
90,007
12,564,966
Replying to @JLOracle @oraclebase @pdevisser
It's a book where you don't know whether the next page is going to make you laugh, cry, wince, shake your head at the utter stupidity of people, or rage against the treatment of NHS staff by successive governments.
2
178
Replying to @oraclebase @pdevisser
Suggested reading: "This is going to hurt" by Adam Kay.
1
3
201
Two months since the last blog note, I hope it's worth the wait: jonathanlewis.wordpress.com/…

Pagination Cost – 2

This note is a follow-on to a note I published a couple of years ago, and was prompted by a question on the MOS community forum (needs an account) about the performance impact of using bind variabl…

jonathanlewis.wordpress.com
2
10
696
Replying to @lemire
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
ORA-600@POUG_ORG23 May 2025
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
1
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/…

maxquerylen

The view v$undostat is a view holding summary information about undo activity that can be used by the automatic undo mechanism to deal with optimising the undo retention time (hence undo space allo…

jonathanlewis.wordpress.com
3
7
516
Replying to @chris_skyflier @martinberx @OracleSK @JLOracle
The days of running oradebug without restriction are numbered! jonathanlewis.wordpress.com/…
1
1
3
460
Replying to @DineshParva
Sorry, no. The optimizer was changing far too quickly for me to do all the testing and modelling to keep up to date with the possibilities.
27
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/…...

POUG2025

AGENDA will be ready by the end of April. But early bird tickets will be long gone by then;) POUG2025 - let's celebrate 10 years together! POUG2025 will be our 10th big conference organized ...

poug2025.konfeo.com
2
4
1
27
2,592
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
46
3,631
Calling out delusional developers... connor-mcdonald.com/2025/04/…

Spaghetti code is Good code

I saw this post on Bluesky over the weekend. Now before you panic, this blog post isn’t going to have any political discussion about DOGE, Trump, Republicans, Democrats and the like. I’…

connor-mcdonald.com
6
8
3
27
1,490
Jonathan Lewis retweeted
Morten Braten@mortenbraten26 Mar 2025
Replying to @StewAshton @FranckPachot @gwenshap @connor_mc_d
If your developers are talking about the database as «the Persistence Layer», you are in trouble 🥸
2
5
13
1,183
"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
Load more