Lightnews — Scholar-powered news

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

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

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

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 · 13d

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 · 13d

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 · 14d

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 · 14d

> ... 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 · 14d

during the test, no intelligence was falsely claimed

1

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

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 · 14d

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 · 14d

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 · 26d

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 · 26d

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 · 27d

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 · 27d

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

Reposted by Martin Berger (berx)

Luiza Nowak @luizafrompoland.bsky.social · Sep 6

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.

4 12