Piet de Visser

Allow me a joke #DBAsRunCronjobs, and cronjobs run the World (and the mail-volume)

...up and running.
Thank You for maintaining those !

When a DBA adds you to their team...
...and in the next 4hrs you receive 180+ mails (from cronjobs...)

Some Things Never Change...
#DBAsRunTheWorld (I have that sticker somewhere.. Thx to @mikedietrichde.com )

Serious ??

The vacuum-cleaner spying + pwd-sniffing on your home-network ??

codetiger.github.io/blog/the-day...

I have been guilty of experimenting with that, way back when global indexes on partitions were a Real Pain.

Things (global indxes in oracle) got a little better now.

hmmm that is not necessarily a Stamp of Quality...

You need to add #sarcasm to that ... Otherwise some innocent DBA will recommend it to his architect: UUIDV7 + Reverse index...

(I should have put bigger CAVEAT stmnts in the blog... )

This thing about "not spreading keys", hot-blocks, and index-contention, I think that is a double-edged sword.

It will depend on Your system, and Your typical load, whether you should pick V4 or V7. I suspect the actual differences will be marginal most cases.
Not many are That Extreme ? Are they?

Agree, That is the Whole Concept.
But both the neighbourpgs, and the python uuid pckge have functions to "extract" from a UUID: time, version, node...

And.. If there is "information" in there, some geek will want to peek into it...
(there is a ugly dutch word for someone who is bit-peek-happy)

Good to Hear. Thx for that.
I hadnt expected anything less.

Not often, but when I came across uuid-data (other database, and/or data-delivered to me) it was UUID-V4. The V7 is relatively Newly spec-ed.

Grinning at this...

Oracle 26ai - UUID v4 available, and looking at v7, Interesting! TL;DR: in Oracle 26ai, there is the new function UUID(), which implements the UUID-V4. Someone also mentioned UUID-V7. I started experimenti...

Great: Oracle v26ai has the capability to generate UUID-V4.
Nice, and interesting to play with.

But I am also expecting at least UUID-V7 in the near future, Right ?

/cc @oracleasktom.bsky.social and @oracleace.bsky.social

simpleoracledba.blogspot.com/2025/11/orac...

Thx for that.

There is more XML out there than you think, notably in "back-ends".
Legacy from the 00s.

See it as a Tribute to the Longevity of some systems, datamodels, designs.

Data Lives Longer....

One cool thing we have since this year’s AI World - #Dev Tips cards for #OracleDatabase

Shout out to @richard.fichtner.dev for the great idea!

Who doesn't want to be part of the 16th edition of APEX World?
Showcase your expertise in APEX to the community! We are seeking presentations for all skill levels, from novices to seasoned professionals, and everything in between.

👉 Visit buff.ly/dJc3ogC to submit your abstract!

Open until Dec 1

"Op 29 oktober mogen we stemmen. Laten we daarbij niet alleen kijken naar verkooppraatjes over betaalbare boodschappen en loze leuzen, maar ook naar het fundament waarop alles rust: een vrije pers, een sterke rechtsstaat en de vrijheid om vragen te stellen." nvj.nl/actueel/gaan...

When using in python (set the module-property on a connection) it will take effect on the next call.

In oracle=pythondb, it piggybacks on actual calls, e.g. when Real work is done and does not cause an additional RT.

Kinda Curious for other drivers.

nb: Not Obsessed by RTs. Not Obsessed. Not.

Yes, Please.
Set. That. Info.

In python it is as simple as assigning a str:
ora_connection.module = 'this is the culprit'

It doesnt even cause an additional round-trip, the setting is piggybacked on the next real call, just so you know.

(did I mention I dont like round-trips... I guess I did)

Also: a Reminder that a good list of blog-bookmarks can be Interesting to have.

You can Learn unexpected things from browsing those blogs...

Thx Tim (@oraclebase.bsky.social).
That is a very read-worthy list.

And a sign that "the community" is still very much Alive.

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.

"nog" is het operatieve woord...

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

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...

#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...

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...

Italian!

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...

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!

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.

Makes me quite curious.

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