Martin Berger (berx)
@martinberx.bsky.social
📤 605
📥 380
📝 242
husband & father; performance seeker; Oracle ACE Alumnus; proud member of @SYM_42; Views are my own;
reposted by
Martin Berger (berx)
Toon Koppelaars
4 days ago
Next interesting topic.
0
2
1
reposted by
Martin Berger (berx)
Roel
4 days ago
Excellent turnout for a 5:30PM session at
#DOAG25
about
#SQLAssertions
- with
@alexnuijten.bsky.social
0
7
3
reposted by
Martin Berger (berx)
Chris Saxon
5 days ago
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
1
25
12
reposted by
Martin Berger (berx)
Aaron Engelsrud
7 days ago
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.
0
0
1
reposted by
Martin Berger (berx)
Oracle AskTOM
14 days ago
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
0
0
1
reposted by
Martin Berger (berx)
Connor McDonald on Database and SQL
18 days ago
From the vault. Those pesky dates as strings.
https://connor-mcdonald.com/2016/05/13/those-pesky-dates-as-strings
0
0
1
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...
)
loading . . .
https://blogs.oracle.com/coretec/post/diagnose-sql-performance-with-dbmssqldiag
19 days ago
0
1
0
reposted by
Martin Berger (berx)
Erich Neuwirth
23 days ago
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.
2
101
33
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)
25 days ago
0
2
0
next level: SQL_Optimizer trace?
add a skeleton here at some point
27 days ago
1
2
0
right now I have to deal with SQLs which I would not be able to store on a 5¼-inch floppy disk single sided ....
27 days ago
1
3
0
Things I never thought I would ever read - today: Logical SQL Reference Guide for Oracle Business Intelligence Enterprise Edition
docs.oracle.com/middleware/1...
¯\_(ツ)_/¯
loading . . .
https://docs.oracle.com/middleware/12212/biee/BIESQ/BIESQ.pdf
about 1 month ago
0
0
0
reposted by
Martin Berger (berx)
Markus Winand
about 1 month ago
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.
loading . . .
QUALIFY clause (window functions)
QUALIFY: filter rows based on window functions
https://modern-sql.com/caniuse/qualify
2
12
7
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 )
about 2 months ago
0
1
0
reposted by
Martin Berger (berx)
Andy Pavlo
about 2 months ago
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-...
4
68
26
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
about 2 months ago
3
1
0
no, the last element in the filter COLUMN IN ('bla', 'yadda', NULL) will NOT do what you might had intended.
2 months ago
0
2
0
reposted by
Martin Berger (berx)
Dr. Neil Gunther
2 months ago
Out of The Queue Comes ... Amdahl’s Law!
www.perfdynamics.com/Papers/amdsy...
0
1
1
reposted by
Martin Berger (berx)
Connor McDonald on Database and SQL
2 months ago
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/
0
3
1
reposted by
Martin Berger (berx)
Piet de Visser
2 months ago
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...
loading . . .
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...
https://simpleoracledba.blogspot.com/2025/09/oracle23ai-and-new-kind-of-history.html
1
3
2
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.
2 months ago
0
1
0
reposted by
Martin Berger (berx)
Martin Bach
2 months ago
🚀 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
loading . . .
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…
https://martincarstenbach.com/2025/09/10/new-debug-flag-simplifies-troubleshooting-ords-container-image-issues/
0
3
2
reposted by
Martin Berger (berx)
Martin Bach
3 months ago
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
loading . . .
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 …
https://martincarstenbach.com/2025/09/08/inline-javascript-and-some-further-details-about-code-delimiters/
2
8
3
reposted by
Martin Berger (berx)
Andy Colvin
3 months ago
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
24
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
!
3 months ago
0
22
3
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
😁
3 months ago
1
13
0
Upgrades are automagic nowadays - aren't they?
@dohdatabase.com
tells us what (..) is going on under the hood - or what can be achieved manually.
3 months ago
0
4
0
@fsimondba.bsky.social
will keep us awake with insights into MAA details. Introduced by
@ludovico.bsky.social
at
#POUG2025
3 months ago
0
4
0
You don't always get what you want ... but we have
@jloracle.bsky.social
on stage at
#POUG2025
now
3 months ago
0
6
0
@tmmdv.bsky.social
has a modern relationship with performance tools ( some is love, some is hate) - and shares his experience on
#POUG2025
3 months ago
0
7
1
reposted by
Martin Berger (berx)
Luiza Nowak
3 months ago
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.
0
12
5
@jasminfluri.bsky.social
has a very special relation to Observability - and convinces us at
#POUG2025
3 months ago
0
9
0
Sylwester Dec starts 2nd day of
#POUG2025
with some heavy lifting
3 months ago
0
4
0
reposted by
Martin Berger (berx)
Priit Piipuu
3 months ago
Who is this mysterious man? Could it be
@chandlerdba.bsky.social
? Strange happenings at
#POUG2025
@sym42.bsky.social
0
5
3
@chandlerdba.bsky.social
closes the official track of day 1
#POUG2025
3 months ago
0
6
1
reposted by
Martin Berger (berx)
Priit Piipuu
3 months ago
@martinberx.bsky.social
and Dawid Welder on network latency at
#POUG2025
@sym42.bsky.social
1
4
1
reposted by
Martin Berger (berx)
Markus Winand
3 months ago
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.
loading . . .
Modern SQL: A lot has changed since SQL-92
SQL has evolved. Beyond the relational model. Discover it now.
https://modern-sql.com/
1
13
3
Andy Colvin gives us more details about the speed of light in rainy meteorological phenomenons
#POUG2025
3 months ago
0
11
0
@connormcd.bsky.social
goes terminal only ( no slides) at
#POUG2015
3 months ago
0
6
0
Fighting food coma at
#POUG2025
@julianfrey.ch
keeps us awake with a great presentation about EM24 (ai)
3 months ago
0
9
0
Now at
#POUG2025
@iarsov.com
shares how we spend our days at RWP
3 months ago
0
8
0
@jolliffe.bsky.social
leads us around the world with 80 dogs at
#POUG2025
3 months ago
0
4
0
#PPUG2025
start the 10th anniversary 🎉 Happy birthday !
@luizafrompoland.bsky.social
&
@ora600pl.bsky.social
3 months ago
0
10
1
reposted by
Martin Berger (berx)
Sabine Heimsath 🇺🇦🇪🇺😷
3 months ago
It feels like they took out the heart of the ACE program 😢
1
7
5
Our first leg to
#POUG2025
3 months ago
2
11
0
reposted by
Martin Berger (berx)
Ilmar Kerm
3 months ago
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.
loading . . .
https://download.oracle.com/otn-pub/otn_software/jdbc/23c/Bugs-fixed-in-23ai.txt
0
1
1
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.
3 months ago
0
0
0
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!
loading . . .
Unveiling the Power of Performance: Integrating SQL Monitoring data into AWR Reports
Overview AWR is a powerful tool in Oracle Database that collects, processes, and maintains performance statistics and workload information…
https://medium.com/@anushavojjola/unveiling-the-power-of-performance-integrating-sql-monitoring-data-into-awr-reports-3d852bdf84cc
3 months ago
0
4
2
reposted by
Martin Berger (berx)
Chris Saxon
3 months ago
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...
loading . . .
https://blogs.oracle.com/sql/post/faster-plsql-in-sql-with-the-automatic-sql-transpiler
0
12
7
reposted by
Martin Berger (berx)
Tanel Poder
3 months ago
Something for Linux block I/O nerds - Linux Storage Stack Diagram (up to kernel v6.16) published:
www.thomas-krenn.com/en/wiki/Linu...
1
20
6
Load more
feeds!
log in