🤦‍♂️- me every time keynote speaker says “on premise”. Three times so far.

New scripts: vstat.sql & dstat.sql for showing Oracle Sysmetric history with 1-minute granularity (both from AWR and regular V$ views) tanelpoder.com/posts/oracle...

Added a blog update about the V$PROCESS_MEMORY_DETAIL auto-population for processes with PGA growth to over 500MB. Enabled in Oracle 19.18+, so no "oradebug dump pga_get_detail" needed, just query the V$ views for a detailed "heapdump": tanelpoder.com/2014/03/26/o...

Do not like that (also, the way to get the traces)

Missed some sessions at @OracleAIWorld? Here's the 2025 mega download of session content. Enjoy! connor-mcdonald.com/2025/10/21/t...

tabhisthybrid.sql: Display Oracle hybrid histograms and filter cardinality estimates tanelpoder.com/posts/tabhis...

Apparently Oracle Docs have embedded videos docs.oracle.com/en/database/...

Any idea what the new (?) light blue color in the SQL Monitor reports mean? It's different between those displayed directly in the console, and the stored & opened ones. It looks as if it tries to show active steps, but does it incorrectly in the OCI console. 1 - in console, 2 - same rep stored

Looks like it's not available anymore, my SR regarding this was closed with something like "Internal bug was submitted for investigation, but hey, we got that alternate features "Look-up By Error or Error Code's First Argument" or "Search by Stack Trace" added which replace it. For real?🤦‍♂️

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.