Lightnews — Scholar-powered news

Reposted by Martin Berger (berx)

Markus Winand @winand.at · 1d

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.

QUALIFY clause (window functions)

QUALIFY: filter rows based on window functions

modern-sql.com

2 6 8

Martin Berger (berx) @martinberx.bsky.social · 13d

one day I will attend HrOUG.
unfortunately not this year....

1 2

Martin Berger (berx) @martinberx.bsky.social · 14d

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 )

1

Martin Berger (berx) @martinberx.bsky.social · 14d

As it works on SERVICE level, it would perfectly match with
DBMS_APP_CONT_ADMIN.CREATE_CHILD_SERVICE
but sadly this fails in ADB-S with
ORA-44798: maximum number of child services exceeded for parent service
even the parent doesn't have any childs 🤯

Martin Berger (berx) @martinberx.bsky.social · 14d

It is a new feature called "smart connect".
docs.oracle.com/en/database/...
in ADB-S it can be enabled as PDB_DBA by using
exec DBMS_APP_CONT_ADMIN.ENABLE_SMART_CONNECTION ('MYDB_low.adb.oraclecloud.com');
1/2

Real Application Clusters Administration and Deployment Guide

Workload management includes load balancing, enabling clients for Oracle Real Application Clusters (Oracle RAC), distributed transaction processing, and services.

docs.oracle.com

1 2

Reposted by Martin Berger (berx)

Andy Pavlo @andypavlo.bsky.social · 15d

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

F3: The Open-Source Data File Format for the Future
SIGMOD 2025

4 21 66

Martin Berger (berx) @martinberx.bsky.social · 15d

> ... so häufig ...
ist das so, oder schlägt hier ein observer bias zu?
Mein Hirn ist so verdrahtet, dass es auf Ungewöhnliches stärker reagiert als auf Erwartetes. Auch wird es dann noch stärker wahrgenommen. - Das muss ich mit viel aktiver Denkleistung kompensieren.
Geht es anderen ähnlich?

1

Martin Berger (berx) @martinberx.bsky.social · 15d

during the test, no intelligence was falsely claimed

1

Martin Berger (berx) @martinberx.bsky.social · 15d

what do you refer "vibe pinning" to ?
my test is ADB-S - which has a specific set of options only.

1

Martin Berger (berx) @martinberx.bsky.social · 15d

good ideas, I didn't think about transactions priority - and did not tamper anything there.
Your 2nd suggestion summarizes vaguely what I intended to do. But ADB-S doesn't let me do this. (no COLOCATION_TAG, or INSTANCE_NAME in connect string is obeyed in ADB-S) .

1

Martin Berger (berx) @martinberx.bsky.social · 15d

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

3 1

Martin Berger (berx) @martinberx.bsky.social · 27d

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

2

Reposted by Martin Berger (berx)

Dr. Neil Gunther @drqz.bsky.social · 28d

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

1 1

Reposted by Martin Berger (berx)

Connor McDonald on Database and SQL @connormcd.bsky.social · 29d

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/

1 3

Reposted by Martin Berger (berx)

Piet de Visser @pdevisser.bsky.social · 29d

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

Oracle23ai, and a new kind of history.

TL;DR: I discovered the view to find sql_history of a session. I can use that to report "what a session has done". Much more Simple than vi...

simpleoracledba.blogspot.com

1 2 3

Martin Berger (berx) @martinberx.bsky.social · Sep 11

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.

1

Reposted by Martin Berger (berx)

Martin Bach @martindba.bsky.social · Sep 10

🚀 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

New DEBUG flag simplifies troubleshooting ORDS container image issues

I previously wrote about troubleshooting the ORDS (Oracle REST Data Services) container’s entrypoint, e.g. the script that’s run whenever an ORDS container starts. This older article is…

martincarstenbach.com

1 3

Reposted by Martin Berger (berx)

Martin Bach @martindba.bsky.social · Sep 8

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

Inline JavaScript and some further details about code delimiters

I recently attended POUG 2025, perhaps the most technical conference in Europe with focus on Oracle Database. My friend Øyvind Isene presented about Multilingual Engine (MLE)/JavaScript and made a …

martincarstenbach.com

2 3 8

Reposted by Martin Berger (berx)

Andy Colvin @acolvin.bsky.social · Sep 7

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

2 5 23

Martin Berger (berx) @martinberx.bsky.social · Sep 6

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

2 22

Martin Berger (berx) @martinberx.bsky.social · Sep 6

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 😁

1 13

Martin Berger (berx) @martinberx.bsky.social · Sep 6

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

4

Martin Berger (berx) @martinberx.bsky.social · Sep 6

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

4

Martin Berger (berx) @martinberx.bsky.social · Sep 6

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

6

Martin Berger (berx) @martinberx.bsky.social · Sep 6

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

1 7