Clop crew hits Oracle E-Business Suite users with fresh zero-day

Have you noticed 23ai FREE background process naming changed from ora_xxxx_SID to db_xxxx_SID? Curious how many shell scripts out there are going to break due to this once (if) 23ai is going to be released

Interesting how tech books are increadibly cheap compared to video courses. TOP www.amazon.com/Troubleshoot... is the best compilation of everything you need to know about Ora perf in 99.9% cases. It's 99$/US, 52€/EU. AOT learn.tanelpoder.com/courses/adva... is most likely great too, but it's 2000$.

Oracle Core: Essential Internals for vibe coders

What can I say, THANK YOU! #POUG2025 @luizafrompoland.bsky.social

@pougorg.bsky.social was great and it’s time to go. Thank you @ora600pl.bsky.social and the whole team for making it a great place to be. All the best in your next decade. See you some day soon.

Premiere at #POUG2025: @jloracle.bsky.social shows pictures on his slides 😁

@tmmdv.bsky.social has a modern relationship with performance tools ( some is love, some is hate) - and shares his experience on #POUG2025

Who is this mysterious man? Could it be @chandlerdba.bsky.social ? Strange happenings at #POUG2025 @sym42.bsky.social

And so, the 10th @pougorg.bsky.social #POUG25 starts. The axeman @ora600pl.bsky.social opening the celebratory champagne bottle the only logical way. If you don't hear from me again know that I went out having the best of times!

Sabrage with an axe. Yep, @pougorg.bsky.social

So it begins! @pougorg.bsky.social

Is there better news? No.

One minor comment: coalesce is not a function, it’s an expression, which allows short circuit evaluation

Unfortunately it's 87%+ AI generated text so better not to promote it.

Link to the topic in the Tuning Guide: docs.oracle.com/en/database/... Link to the VLDB paper Oracle wrote on the topic: www.vldb.org/pvldb/vol16/... P.S. I really enjoyed seeing paragraph 2.1 - "hints obligate the optimizer to honor actions they specify".

We live in the different worlds :) As a developer I find this dashboard distinctly unhelpful. Let's say I have an incident: p99 of resp time is above the targets. Will AAS tell us what ails those queries? Not really. This is the reason why we use SQL trace with extra tooling.

Were you aware of the two hidden columns in CDB-Views? Learning something new every day is the best part of my job. And as you can see and read on the blog, thanks to YOU, I learn a lot. This one I learned from Johannes Ahrends at my workshop for ora2know in Munich in early July this year. Were…

Did you know ADDM is pronounced Adam? docs.oracle.com/en/database/...

A new post about a defect / limitation in the optimizer's handling of bind variables that turns out to have an important impact on the usefulness of the "offset / fetch next" syntax for pagination: jonathanlewis.wordpress.com/2025/08/01/b...

With all the new stuff in the 23ai RUs, it can be easy to overlook some cool changes in 19c such as Schema annotations have been backported to 19.28 These enable you to add key-value metadata to describe tables, columns, and other database objects

UKOUG Annual Conference CfP is finally open sessionize.com/ukoug-annual...

While looking at node-oracledb docs I noticed a weird dbOp parameter node-oracledb.readthedocs.io/en/latest/us... apparently this is a very old, obviously unused, feature oracle-base.com/articles/12c....

Speed SQL results Attempt #2: 10 correct in 39 seconds ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ ✔ #SpeedSQL devgym.oracle.com/pls/apex/f?p...

TIL: have to use deterministic for a function so its result can be used by a smart scan.

Why oh why

One good thing about ChatGPT and alike (at least for now) is: its output is easily recognizable.

Retro blog post. PL/SQL in 21c gets amazing new loop iterators. https://connor-mcdonald.com/2021/01/15/pl-sql-in-21c-gets-amazing-new-loop-iterators/

I love the “2-3 hours” part

This look broken, as cardinality estimates between table and index are inconsistent + you can’t get more rows out of the table

After patching your Oracle Database you might see indexes flying in during an import. How did that happen?

It is now safe to assume 23ai is dead. Most will wait till the next Long Term release since 19c premier support has been extended till Dec 2029.

Those fateful words .... "we are working with an EAV (entity-attribute-value) schema, all objects are stored in a single table...and we are having a performance issue" Yer reckon?

We think you'd enjoy #POUG2025 too. You can meet @jloracle.bsky.social and the rest of the gang in September. Last tickets with 20% discount: poug.org/edycja/poug-...

0x.tools xCapture v3: Linux Performance Analysis with Modern eBPF and DuckDB 👀👀 tanelpoder.com/posts/xcaptu...

#POUG2025 speakers - please stand up! We're still waiting for all confirmations, but we already know our agenda this year will be legendary 😎

To those struggling with index skip scan cost being too low, check this out.

Why Exadata System Statistics are not gathered by default? Rhetorical question.

Only one more day to submit for POUG 2025 CfP ends TOMORROW! Take this final chance to be part of this event and enter your abstract on https://sessionize.com/poug-2025/. @POUG_ORG #POUG25 See all Events and CfPs on www.clocwise.org.

The new MOS portal uses base.js script which is 9MB. Seriously?

Change your Oracle SSO passwords now.

Activating kernel parameters is different in OL9 - Oracle Linux: Kernel Parameters are Not Reflected using grub2-mkconfig (Doc ID 2989671.1). After upgrade to OL9, I ran my playbooks to configure servers, but databases kept crashing every few days. Then orachk told expected kernel parameters missing

I've updated my Tampermonkey plugin for MOS to keep HTTP session alive longer - please have a test and let me know if it works for you. greasyfork.org/en/scripts/2...

One week left to submit your #POUG2025 session. 👀 sessionize.com/poug-2025/

Tomcat is included with GI and starting with 19.24 its version is 9. In 19.26 Tomcat base version is 9.0.98 so it fits this CVE. Expect some patching.

Also it’s nice to visualize undo extents as a ring www.pythian.com/blog/technic...

An interesting new feature of the DBMS_SPM since 19.22: Bug 34534504 PERF_DIAG: Need a dbms_spm API to Create Plan Baseline to Get Good Execution Plan for a SQL_ID

Sounds scary but no details: Bug 36777010 oracle sequence suddenly go back to older number causing inconsistent application behavior

Download all the patches you need, for all the platforms you need, using AutoUpgrade and just one command. Perhaps you've logged in to MOS to download patches for the last time....

The joy of writing blog notes - from time to time someone attaches a comment that will add real value for your readers (and yourself, of course). In this case Mikhail Velikikh: mvelikikh.github.io/blog/