Next interesting topic.

Excellent turnout for a 5:30PM session at #DOAG25 about #SQLAssertions - with @alexnuijten.bsky.social

Coming in Oracle AI Database #SQL assertions These enable you to create cross row, cross table constraints with SQL standard syntax CREATE ASSERTION … CHECK ( [ NOT ] EXISTS ( <query> ) ) @toonkoppelaars.bsky.social explains at #DOAG2025

PeopleSoft logs are a goldmine. With the right observability stack, you can spot patterns before outages, predict performance issues, and reduce support calls. Visibility isn't a luxury; it's control.

Not long to go! AskTOM Office Hours. Oracle experts will be onlinefor you. Next session starts 11 November at 19:00 UTC https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_event_id=79923585559994835692303731425966476480

From the vault. Those pesky dates as strings. https://connor-mcdonald.com/2016/05/13/those-pesky-dates-as-strings

note to self: for a proper overview about specific SQLs executions, use DBMS_SQLDIAG.REPORT_SQL let it write a zipfile to a DIRECTORY use level => 'ALL' enjoy additional content int the zip (more than shown in blogs.oracle.com/coretec/post... )

To all my US friends, with regard to a parliament not convened. In Austria, in 1933 the parliament became nonfunctional because all 3 presidents resigned, so for some time nobody had the authority to convene the parliament. This led to dramatic consequences.

note to self: when investigating long PARSE time, don't only rely on SQL Monitor Reports (to check individual SQLs for parsing) - always crosscheck with ASH! (SQL Monitor Report does not always show the full beginning of the SQL_IDs parsing)

next level: SQL_Optimizer trace?

right now I have to deal with SQLs which I would not be able to store on a 5¼-inch floppy disk single sided ....

Things I never thought I would ever read - today: Logical SQL Reference Guide for Oracle Business Intelligence Enterprise Edition docs.oracle.com/middleware/1... ¯\_(ツ)_/¯

Oracle 26ai¹ was released yesterday. From the SQL standpoint it's worth mentioning that is has got the QUALIFY clause: I bet this starts an avalanche (there are already PostgreSQL patches). modern-sql.com/caniuse/qual... ¹ 26ai is the marketing version, 23.26.0 is the technical version.

Note to self: the time you gain by faster typing you loose by searching for typos. (no, they do not need to care about _JAVA_OPtIONS )

Our SIGMOD paper with our friends at Tsinghua + @wesmckinney.com + @pateljm.bsky.social on creating a next generation open-source data file format is out. F3 is a future-proof file format avoids the mistakes of Parquet. 📄 Paper: db.cs.cmu.edu/papers/2025/... 📁 Code: github.com/future-file-...

A nice riddle: what happened between these 2 screenshots? workload is exactly the same, eCPUs are constant, instances are constant, no change in data, tables, indexes, ... hint: 23ai

no, the last element in the filter COLUMN IN ('bla', 'yadda', NULL) will NOT do what you might had intended.

Out of The Queue Comes ... Amdahl’s Law! www.perfdynamics.com/Papers/amdsy...

Previously on the blog. The performance report you are NOT using. https://connor-mcdonald.com/2021/04/30/the-performance-report-you-are-not-using/

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

Little detail I read a long time ago (guess what book?) and verified today: "minimum active SCN", Delayed Block cleanout and ORA-1555. oh what join in the little details, and how another "totally independent" session can kill your users experience.

🚀 New DEBUG=TRUE flag makes ORDS container debugging way easier! 🐳 No more hacks—see exactly what’s happening during startup in ORDS 25.2.3. 💡 Here’s how it works (with live example): 👉 martincarstenbach.com/2025/09/10/n... #ORDS #DevOps #Oracle #containers

You can define your own inline JavaScript code delimiters in Oracle MLE — even emojis (💥). A small but useful detail I explored after a great question from @oyvindisene.bsky.social at #POUG2025. Blog post 👉 martincarstenbach.com/2025/09/08/i... #oracle #MLE #javascript

Wow…can’t believe it took me 10 years to get to @pougorg.bsky.social but it delivered in every possible way. So great to see old friends and I haven’t learned that much at a conference in a very long time. ⭐️⭐️⭐️⭐️⭐️

#POUG2025 is closing down. Thank you @luizafrompoland.bsky.social , @ora600pl.bsky.social , all the sponsors, speakers, attendees and people in the background. Hope to see you all at #POUG2026 !

Traditionally, the last presentations at #POUG are some easy stuff for an exhausted audience. @christophlutz.bsky.social will for sure follow this tradition this year #POUG2025 😁

Upgrades are automagic nowadays - aren't they? @dohdatabase.com tells us what (..) is going on under the hood - or what can be achieved manually.

@fsimondba.bsky.social will keep us awake with insights into MAA details. Introduced by @ludovico.bsky.social at #POUG2025

You don't always get what you want ... but we have @jloracle.bsky.social on stage at #POUG2025 now

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

This is the #POUG essence. You can drink beer, you can party late, but you will also show up at 9 am the next day in the venue because the sessions are that good.

@jasminfluri.bsky.social has a very special relation to Observability - and convinces us at #POUG2025

Sylwester Dec starts 2nd day of #POUG2025 with some heavy lifting

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

@chandlerdba.bsky.social closes the official track of day 1 #POUG2025

@martinberx.bsky.social and Dawid Welder on network latency at #POUG2025 @sym42.bsky.social

After being « gone fishin' » during summertime I just updated my website for the releases that happened during that time: * MariaDB 11.8 and 12.0 * Oracle 23.9 * Db2 12.1.2 All charts on modern-sql.com and use-the-index-luke.com are updated.

Andy Colvin gives us more details about the speed of light in rainy meteorological phenomenons #POUG2025

@connormcd.bsky.social goes terminal only ( no slides) at #POUG2015

Fighting food coma at #POUG2025 @julianfrey.ch keeps us awake with a great presentation about EM24 (ai)

Now at #POUG2025 @iarsov.com shares how we spend our days at RWP

@jolliffe.bsky.social leads us around the world with 80 dogs at #POUG2025

#PPUG2025 start the 10th anniversary 🎉 Happy birthday ! @luizafrompoland.bsky.social & @ora600pl.bsky.social

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

Our first leg to #POUG2025

DRCP in JDBC 23 is now actually usable when using LDAP connections - download.oracle.com/otn-pub/otn_... Bug 36954608 - INCOMING LDAP CONNECTIONS INCORRECTLY SHOW DRCP SESSION PURITY AS NEW RATHER THAN SELF Give @romanfj.bsky.social a beer in POUG for actually finding this curiosity.

I just phrased a concept how to call code AS an user in a PDB and it is executed as SYS in CDB$ROOT to ChatGTP - and it confirmed this would be feasible. At least it didn't suggest a shorter way and also commented why and where there are safety checks implemented which will prohibit it normally.

When sharing Oracle performance data, AWR DUMPS (not reports) is a great & simple way. Since 19.24 they now also can contain SQL MOnitor Report data. Details in medium.com/@anushavojjo... A great post by Anusha Vojjola!

Get faster PL/SQL in #SQL with alter session set sql_transpiler = on => database will convert eligible functions to SQL Read my latest post for details on What can be transpiled Transpiler vs scalar macros Functional differences Impact of function-based indexes blogs.oracle.com/sql/post/fas...

Something for Linux block I/O nerds - Linux Storage Stack Diagram (up to kernel v6.16) published: www.thomas-krenn.com/en/wiki/Linu...