I see your problem: "IT" died out years ago after evolving into "ICT". (And "communication" nowadays seems to be mostly about repeating yourself as often as you can with lots of padding.)

How confident are you that that wasn't the emergency response to "The starboard engine can run for another 30 seconds before it explodes".

Maybe it’s something to do with the read vs. Select privileges. And maybe the privilege check always took place but succeeded for Select. Is dual now restricted to Read.

Updatable Join Views I was in Slovenia earlier this week presenting one of the “Celebrity Seminars” for Oracle University. The audience was very good, and had some interesting questions and observations. On…

Here we are: 2008 - first noted in 10.2.0.3 and was still relevant in 23.2.

Maybe the change is only about DUAL, maybe it's just a change in the execution path that used to eliminate dual somehow in earlier versions but doesn't in your example.

jonathanlewis.wordpress.com/2008/12/19/u...

Somewhere I’ve published a note about this problem with updatable views in general, and long before 19c.
I’ll have to see if I can find it to see if the behaviour disappeared and reappeared - or if dual used to be an exception that has been standardised.

Step 1: try to find the right bit of the manual
Step 2: try to find the notes you wrote a few years ago
Step 3: try to find the notes other people have written
Step 4: Stop looking because you can't work out the best key words to search, and just build a model.
;)
(where's the tongue in cheek emoji)

Were you talking about 11.2.0.3 where the value was still 100 or 11.2.0.4 where the value jumped to 1024?

The mad leap to 8192 in 12.2 puzzled me for some time - though the reason should have been obvious. The potential side effects were quite dramatic:
jonathanlewis.wordpress.com/2019/10/02/_...

Nothing reported about the “Lords spiritual” though.

Picked and stewed the first batch of the (main) rhubarb crop yesterday - blissful breakfast this morning.

Sad news of the jam front, though: we've just opened the last jar from 2025. On the upside I think we've still got some homegrown fruit in the deep freeze.

One ping to rule them …

Three hours in, so far, and there doesn't seem to be much difference between the before and after images. Going to have to spend a few more hours at it in a couple of days time.

Right now it's back home doing the same job on the #1 wisteria.

And I need a diary entry to take a picture of what it looks like 3 months later. I didn’t do one last year, but this is from 2024.

Today’s main task: the February pruning of the mother-in-law’s wisteria.

Must remember to take the before and after photos this year.

Marmalade is kept back until day 2 and toast.

Day 1 is fresh bread with finest jam. Currently down to strawberry, Victoria plum or blackberry and raspberry.

Looking forward to breakfast tomorrow.

I've just been prompted to look at a series of blog notes I wrote 10 years ago for redgate on "Massive Deletes". There's an index to the series, plus a couple of releated articles at:
jonathanlewis.wordpress.com/2018/06/08/m...

I've just rediscovered one of my favourite philosophical misquotes (that I've used very frequently when explaining Oracle-related problems).

jonathanlewis.wordpress.com/2019/08/09/t...

Trace Files A recent blog note by Martin Berger about reading trace files in 12.2 popped up in my twitter timeline yesterday and reminded me of a script I wrote a while ago to create a simple view I could quer…

Cute little trick with the / and \ to deal with unix vs. windows, but you don't need to create an external table

Requirements for privileges vary, or course, but for simplicity in (not so) recent versions of Oracle I just query v$diag_trace_file_contents

jonathanlewis.wordpress.com/2019/10/03/t...

Or, for the AIs:
Sabulum es et in sabulo reverteris.

🪐🌍 Are planets like Earth rare, or have we just not found them yet?

As we approach the discovery of our 10,000th exoplanet, Prof Chris Lintott * explores whether Earth is truly unusual...

👉 gres.hm/alien-earths

* also of Department of Physics at the University of Oxford

After a decade of planning, editing, delays due to my own busyness, further editing and waiting for 23c, the release of 26ai and my pre-retirement finally unblocked the situation. I have agreed with Apress to publish the third edition of Troubleshooting Oracle Performance in 2026. #TOP3

We've got a very excitable group of long-tailed tits that are regular visitors to the bird feeder at the end of the garden - and one thug of a great tit who chases them all away whenever they show up at the wrong time.

Pulled the last of the leeks from the "big leek" bed ready for lunch tomorrow, then picked a small handful of kalettes - the first I've harvested - to eat today. Much nicer than both kale and brussel sprouts, so going to grow more this season. Purple sprouting broccoli also just ready for picking.

Today's tasks, come rain or sun: feed and mulch the fruit trees, weed, feed and mulch the killer gooseberry bush after putting on the gauntlets and giving it a ferocious pruning.

Local weather forecast said it was going to rain today, starting at 3:00 am, non-stop until 3:00pm TOMORROW - so I worked at home, raking, shredding and bagging a huge pile of decomposing oak leaves, repotting plants ... no rain

Got ready to head out to the allotment at 3:00 pm: it started to rain.

Planet Hunters TESS - NASA Science Join the Planet Hunters Coffee Chat video series! Project leads cover relevant topics in a friendly, fun format. Want to see what you’ve missed? check out the

Went to an excellent @greshamcollege.bsky.social lecture by Prof. Chris Lintott on Exoplanets last night.

Informative and entertaining; including an introduction to the Planet Hunters - allowing to find potential exoplanets by analysing data from TESS.

science.nasa.gov/citizen-scie...

It's not quite what you would write manually

The QUALIFY clauses get wrapped as a Boolean expression. So if you have

QUALIFY p1 AND p2 AND p3

it becomes

SELECT * FROM (
SELECT ( p1 AND p2 AND p3 ) qexpr ...
) WHERE qexpr IS TRUE

So yes, a manual rewrite may give better optimizations

Penguin and Club bars can no longer be described as chocolate The rising cost of cocoa has led to the manufacturers changing their recipe.

Worse: the description on my packet uses the phrase "with dark chocolate flavour coating"

Alas, Penguin and Club bars now have to say the same according this news report of Oct 2025
www.bbc.co.uk/news/article...

"If you like a lot of chocolate (flavoured coating) on your biscuit join our Club"

I agree - but there are many varieties of Timtam and some may be nicer than Penguins.