Lightnews — Scholar-powered news

Piet de Visser @pdevisser.bsky.social · 7h

Recommended!
Even if you only go to conferences for the food and the drinks...

I had a lot of good learning, a lot of good connections, and quite a lot of Fun from being in this program.

Oracle ACE Program @oracleace.bsky.social · 9h

🚀 We’re excited to announce a brand-new entry path to the Oracle ACE Program: ACE Apprentice—launching at Oracle AI World! ♠️

The ACE Apprentice level is designed to kickstart your journey as an Oracle advocate and unlock your potential within the global community. 🔒 🔑 💻

👉 ace.oracle.com/apprentice

2

Piet de Visser @pdevisser.bsky.social · 11h

"nog" is het operatieve woord...

Piet de Visser @pdevisser.bsky.social · 11h

Beste @ftm.nl ,

ik waardeer jullie Hogelijk.
Ga. Zo. Door.

Maar ik wil Niet Nog een App op mijn telefoons (inloggen, notifiations, tracing...).

Please, maak content (text en podcasts) ook via het ouderwetse www met een (anonieme, no-javascript, ad-blocked... ) beschikbaar.

#followthemoney

Follow the Money @ftm.nl · 4d

Dure en intimiderende rechtszaken zetten onafhankelijke journalistiek nog steeds onder druk. Ook Follow the Money krijgt regelmatig dreigbrieven. Maar wij laten ons niet de mond snoeren.

Bescherm onze persvrijheid en steun radicaal onafhankelijke journalistiek.

Sluit je aan 👉 www.ftm.nl/word-lid

2

Piet de Visser @pdevisser.bsky.social · 13h

#joelkallmanday
We tend to forget that troubleshooting is mainly just about Clear and Calm thinking..
pdvfirstblog.blogspot.com/2025/10/simp...

Simplicity, Troubleshooting, #JoelKallmanday

TL;DR: You don't have to be a genius to solve problems. And there is no shame in not-knowing or not understanding all the geeky details. Ma...

pdvfirstblog.blogspot.com

3 5

Piet de Visser @pdevisser.bsky.social · 13h

Apart from all the buzz around the "release" of 26ai, Today is also #joelkallmanday ,
Coordinated by @oraclebase.bsky.social, our community blogs in with that hashtag to remember Joel ...
pdvfirstblog.blogspot.com/2025/10/simp...

Simplicity, Troubleshooting, #JoelKallmanday

TL;DR: You don't have to be a genius to solve problems. And there is no shame in not-knowing or not understanding all the geeky details. Ma...

pdvfirstblog.blogspot.com

4 5

Piet de Visser @pdevisser.bsky.social · 3d

Italian!

Peter Nosko 🇩🇪-🇺🇸 🍉 #227,627 #EraseTheOnePercent @pnosko.bsky.social · 3d

Which one are you?

1 2

Reposted by Piet de Visser

SQLDaily @sqldaily.bsky.social · 8d

Processing one row at a time leads to lots of round-trips to the #database

This is SLOOOOOOOW

It's faster to batch records and send many in one call

How much faster?

@pdevisser.bsky.social tested with Python and batching inserted 150x more rows!

oracle23ai and python - eliminate RoundTrips.

TL;DR: Searching for RoundTrips to eliminate between python and Oracle. In this case, we "collect" the individual inserts to do them in a fe...

buff.ly

2 3

Piet de Visser @pdevisser.bsky.social · 14d

Good Memories.

I was read to.
I did some reading to my kids...
Not sure if it worked in our case,
but I can definitely Recommend this.

Rae Radford @raeradford.bsky.social · 14d

#BookSky #BlueSky

1 3

Piet de Visser @pdevisser.bsky.social · 14d

Makes me quite curious.

Piet de Visser @pdevisser.bsky.social · 15d

Remember these stickers...
(the Croatian variety is "Meni Radi" )

1

Piet de Visser @pdevisser.bsky.social · 15d

got a concept ready...

#JoelKallmanDay

@oracleace @OracleDatabase

Tim Hall @oraclebase.bsky.social · 21d

Joel Kallman Day 2025 : Announcement

oracle-base.com/blog/2025/09...

#JoelKallmanDay

@oracleace @OracleAPEX #orclapex @OracleDatabase

3

Piet de Visser @pdevisser.bsky.social · 16d

And allow me to ask:

Can/Will v$sql_history replace sql_trace in the future ?

Piet de Visser @pdevisser.bsky.social · 16d

Got it to work, Properly.
(including the elusive "hidden" parameter)

simpleoracledba.blogspot.com/2025/09/orac...

With Thanks to ...
@martinberx.bsky.social (blog + tips)
@connormcd.bsky.social (office hrs)
@gvenzl.bsky.social (images)
For hints, answers and container-images.

Oracle23ai, python, and v$history for your developers...

TL;DR: We got the v$sql_history feature configured for use in development. Python programs can now report on the SQL statements done Exactly...

simpleoracledba.blogspot.com

1 4

Piet de Visser @pdevisser.bsky.social · 17d

About those chocolate tastings....

/cc @oracleace.bsky.social
@jen-nicholson.bsky.social

Conrad Hackett @conradhackett.bsky.social · 17d

More chocolate, more Nobel prizes
https://www.scientificamerican.com/blog/the-curious-wavefunction/chocolate-consumption-and-nobel-prizes-a-bizarre-juxtaposition-if-there-ever-was-one/

Scatterplot showing a correlation between rates of chocolate consumption and rates of Nobel Laureates

5

Piet de Visser @pdevisser.bsky.social · 19d

You did send an invoice, I suppose?

1 1

Reposted by Piet de Visser

Tim Hall @oraclebase.bsky.social · 21d

Joel Kallman Day 2025 : Announcement

oracle-base.com/blog/2025/09...

#JoelKallmanDay

@oracleace @OracleAPEX #orclapex @OracleDatabase

1 13 20

Piet de Visser @pdevisser.bsky.social · 22d

Hint: More is not always better.

Think: Less is More...

(insert quote from Goethe:
In der Beschränkung zeigt sich erst der Scrum-Master....)

Piet de Visser @pdevisser.bsky.social · 22d

Phoenix Projects come and go,
But the Mythical Man Month will always be so.

(couldnt resist... a small tribute to F.P Brooks)

#IT
#projects
#Development
#Operations
#DEVOPS

1 1

Piet de Visser @pdevisser.bsky.social · 23d

The V$SQL_HISTORY is a Promising new feature in Oracle23ai but still has some limitation.
I wanted more so I picked up an old trick...

simpleoracledba.blogspot.com/2025/09/orac...

Not perfect, but this works, even in in existing older versions.
#oracledatabase
#python

Oracle23ai, sql_history, and some options, including for v19

TL;DR: The V$SQL_HISTORY is Very Cool Idea, but it still has some limitations. Also, it is not available in older versions... so I examined...

simpleoracledba.blogspot.com

6

Reposted by Piet de Visser

Connor McDonald on Database and SQL @connormcd.bsky.social · 27d

New post! MERGE is 23ai is even cooler than first appears...

connor-mcdonald.com/2025/09/18/m...

MERGE in 23ai – so much more than RETURNING

Oracle ACE Andrej Pashchenko recently did a blog post covering a nice addition in 23ai, the ability for MERGE to use the RETURNING clause. Check his post for several examples, but as quick TL;DR, h…

connor-mcdonald.com

3 8

Piet de Visser @pdevisser.bsky.social · 28d

It was actually @martinberx.bsky.social who pointed it out during a discussion on timing + tracing.

1- GREAT Feature.. bcse SID-Relevant Info, accessible by client/tools/devs, right and at the end of a specific session...
2- Plse make it default-on...
3-Backport, Please...???

Piet de Visser @pdevisser.bsky.social · 28d

In all the #Oracle23ai New-Feature-stories, how did this one got lost ??

The information in the new V$SQL_HISTORY is a Hidden Gem!

Can we give this thing a bit more attention?
Great Potential as a "Problem Fixer" for Devs, Ops, and DBA's...

simpleoracledba.blogspot.com/2025/09/orac...

Oracle23ai, and a new kind of history.

TL;DR: I discovered the view to find sql_history of a session. I can use that to report "what a session has done". Much more Simple than vi...

simpleoracledba.blogspot.com

1 2 3

Piet de Visser @pdevisser.bsky.social · Sep 13

FF.
(plus 1)

Piet de Visser @pdevisser.bsky.social · Sep 5

This is Most Likely ... Exactly. Spot. On. True.

Thx for kicking this out there.
(and only pass it on to those bosses that are Worthy to know.. )

Nicolas Fränkel 🇺🇦🇬🇪 @frankel.ch · Sep 5

MIT says #AI isn’t replacing you… it’s just wasting your boss’s #money

MIT says AI isn’t replacing you… it’s just wasting your boss’s money

MIT research shows most companies are failing to profit from AI with fewer than 1 in 10 pilots succeeding which proves human skills remain vital in the job market.

www.interviewquery.com

1

Piet de Visser @pdevisser.bsky.social · Sep 5

Understand.
Understand...

Please pass on my Best Regards to the person concerned.