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.

About those chocolate tastings.... /cc @oracleace.bsky.social @jen-nicholson.bsky.social

Joel Kallman Day 2025 : Announcement oracle-base.com/blog/2025/09... #JoelKallmanDay @oracleace @OracleAPEX #orclapex @OracleDatabase

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

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

New post! MERGE is 23ai is even cooler than first appears... connor-mcdonald.com/2025/09/18/m...

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

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

It feels like they took out the heart of the ACE program 😢

Yeah! Pinging conference ppl everywhere....

I suddenly have a much higher opinion of ChatGPT..

Here I am researching my talk for a Conference later this autumn. And this code, ready to copy + run, pops up. (it IS one Good Sounding number...)

Prompt-Engineer....

Yep. That is how you do boardroom-sale of AI.

An AI reply is only as good as its Reader. plus An AI reply is only as good as its Provider. Using AI in search is Fine, If you Know What You are Doing... (now over to some minor-guru-thought-leader to Claim this and re-phrase this stmnt for his minions...)

In the runup to #POUG2025 I suddenly get all sorts of Polish stuff in my timelines.. ? /cc @pougorg.bsky.social @luizafrompoland.bsky.social

Brilliant idea

NOT obsessed with network-latency. Not. Obsessed. But I do tweak python programs to find, report, and avoid latency... (and it is interesting and kinda fun) /cc @oracleace.bsky.social @pougorg.bsky.social Looking fw to discuss at #poug2025 simpleoracledba.blogspot.com/2025/08/orac...

Yep: Roundtrips, and other items to watch out for when using python and Oracle. (oh, and those cute cars were also built in Poland and in Yugoslavia... and probably in more places: There is your link with #POUG2025 and @pougorg.bsky.social ) cjones-oracle.medium.com/round-trips-...

.. and on #latency and #roundtrips, I had a few chats with Christopher Jones, the ProductManager for python-oracledb, the driver to connect python to your Oracle RDBMS. If you are working with #python and #Oracle: check his blogs: cjones-oracle.medium.com /cc @oracleace.bsky.social

Network, Latency. The eternal problem for distributed applications... At least 3 sessions at #poug2025 are about "latency" And I keep digging into RoundTrips and RTTs: simpleoracledba.blogspot.com/2025/08/orac... /cc @oracleace.bsky.social @pougorg.bsky.social #oracle23ai #python

Probably Correct. But also: maybe want to keep this a guarded secret to avoid a grey-wave ?

How do you apply "Green" practices in your work ? Desired answer: we buy Expen$ive green paint... (bigger budget is more Status for Boss, more commi$$ion for $alesrep) My Answer: make systems More Efficient, use less resources, consume less electricity.... (not always what they wants to hear...)

There is an Old Proverb... To Find Typos... Publish your blog.

hm. today we still laugh at this....

Ancient Wisdom to make a program faster: Dont Execute it. How to skip "unnecessary" code, and thus avoid RoundTrips... simpleoracledba.blogspot.com/2025/08/orac... #Oracle #python

@pougorg.bsky.social is in a month. I got my "concept" for prez accepted, but,... They turned it into a "workshop". Been thinking about it. I'll try to make it interesting, with "audience participation" (BYODatabase!). Image of me thinking...

Das Programm der DOAG 2025 Konferenz + Ausstellung ist online! Aus den zahlreichen Einreichungen hat unser Programmkomitee eine hochklassige Agenda mit rund 300 Sessions zusammengestellt. Jetzt im Programm stöbern und Early-Bird-Tickets sichern! scomp.ly/Aw8gZoL #DOAG2025

Funny but serious... Many systems HANG ! Checking... Lock-Wait, Find blocker-session... Someone had (justly) updated parent-data via a SQL-tool, session still open... (forgotten to hit commit-button...) Grinning at "lifetime learning" ... And thinking: "the other system has autocommit...

Messing about with "code"... Can just say that the art of #defensiveprogramming needs too be re-visited... Nobody seems to check for (input-)errors much, and that is potentially a (security)risk. I guess a lot of "incidents" are either not-noticed, or kept silent. en.wikipedia.org/wiki/Defensi...

Allow me a little Rant: No, I did Not Re-Invent the wheel... I knew perfectly well "The Concept of the Wheel" Knowingly, I built a custom-wheel to make your particular contraption run Faster... (and to my own surprise, it worked...) Look at is as fixing a kludge with another kludge.

The "epoch" function got better by turning it into an SQL-Macro. simpleoracledba.blogspot.com/2025/07/orac... With Thanks to Erik, Jonathan and Priit for their remarks. /cc @evrocs.bsky.social @jloracle.bsky.social @ppiipuu.bsky.social @oracleace.bsky.social

That sinking feeling... Writing the program was Easy. Adding the Error Handling .... will be a nightmare. (and Handling an error does not even mean Solving the error)

TIL: There are 42 days to go before #POUG2025 in Poznan. I'm sure @luizafrompoland.bsky.social and @ora600pl.bsky.social have everything Ready.

OK, so I did my own function to get the epoch from an oracle database... Would there be support for asking a for format mask, a bit like.. TO_CHAR ( systimestamp, 'EPOCH.FF9' ) ?? simpleoracledba.blogspot.com/2025/07/orac... /cc @oracleace.bsky.social @gvenzl.bsky.social @thatjeffsmith.com

Often Very True.

Yes.

Every DBA should Know, and Practice this topic to gain solid understanding of redo-log mechanism. Knowing how things really work make you so much more Capable and Confident using any backup/recovery mechanism.

Ditto with Devs asking their ChatGPT to write code...

Latency ? - Hate it. Python ? - Like it. Demo is with latest Oracle23ai, but scripts work with Oracle19c just fine... And I am not obsessed with Latency or Chattiness. Just like to verify... simpleoracledba.blogspot.com/2025/07/orac...

In Troubleshooting slow components. In cloud-condemned-only systems... It is not the Bandwith (you can buy Bandwith). It is the Chattiness (you Can Not buy Faster Speed-of-Light). Enjoy some good music while you wait... www.youtube.com/watch?v=t9f_...

#SmartDB #StoredProcedures

some playful scripts ended up unexpectedly useful... And may prove useful again soon. simpleoracledba.blogspot.com/2025/07/orac...

Best Classic opening of an email-text.. "I am not sure you realise how much effort....." (yes, I do, I wrote some of it... I'm telling you to THINK, not bean-count) #software #DevOps #devoops

In the category "Why???" and also "Do NOT use this in Production". But it was Kinda fun to do (in test...), and proved surprisingly useful over time. simpleoracledba.blogspot.com/2025/07/orac... Will probably write a followup... #oracle #python

It is a Special Day when you hear "CROACK" from the desk next to you. #blastfromthepast #TOAD #ORACLE_LIFE (some of you call it "Ribbit", the logo is a friendly looking frog...) It Lives!

Take it Easy... Some ways to throttle-down your program(s) to Not Overload the system... (your sysadmin will thank you for it...) /cc @oracleace.bsky.social simpleoracledba.blogspot.com/2025/07/orac...

An Oracle-Guru once had an email-signature: Sometimes you are the pigeon, sometimes you are the statue. I used to add: Sometimes you are the Developer, sometimes you are the DBA/sysadmin/root. Now we have: Sometimes you are the DevOps, sometimes you are the CISO...

There must be a long German word for this. Trying to understand your own code from 10 months ago... #python #oracle #RTFM #documentation This is why you should only create Simple, Very Simple, code. And always "explain before you write, explain after you write"...