Martin Berger (berx)
@martinberx.bsky.social
husband & father;
performance seeker;
Oracle ACE Alumnus;
proud member of @SYM_42;
Views are my own;
performance seeker;
Oracle ACE Alumnus;
proud member of @SYM_42;
Views are my own;
Reposted by Martin Berger (berx)
Only one more day to submit for
APEX World 2026
CfP ends TOMORROW!
Take this final chance to be part of this event and enter your abstract on https://apps.nloug.nl/ords/r/nloug/abstracts.
@nl_oug #apexworld #aw26 #orclapex
See all Events and CfPs on www.clocwise.org.
APEX World 2026
CfP ends TOMORROW!
Take this final chance to be part of this event and enter your abstract on https://apps.nloug.nl/ords/r/nloug/abstracts.
@nl_oug #apexworld #aw26 #orclapex
See all Events and CfPs on www.clocwise.org.
November 30, 2025 at 1:00 PM
Only one more day to submit for
APEX World 2026
CfP ends TOMORROW!
Take this final chance to be part of this event and enter your abstract on https://apps.nloug.nl/ords/r/nloug/abstracts.
@nl_oug #apexworld #aw26 #orclapex
See all Events and CfPs on www.clocwise.org.
APEX World 2026
CfP ends TOMORROW!
Take this final chance to be part of this event and enter your abstract on https://apps.nloug.nl/ords/r/nloug/abstracts.
@nl_oug #apexworld #aw26 #orclapex
See all Events and CfPs on www.clocwise.org.
Reposted by Martin Berger (berx)
Absolutely this by @connormcd.bsky.social . Before I started going to user groups I thought I was good at Oracle stuff. But I got so much better when I started going - not just by learning more but also having all these smart friends I could now ask about loads of stuff!
"Oh, I'll just attend the webinar"
"Maybe I will download the slides"
Neither of that will EVER reproduce the value of sharing your knowledge and experiences face to face with your community colleagues at a meetup.
Support your local user group
"Maybe I will download the slides"
Neither of that will EVER reproduce the value of sharing your knowledge and experiences face to face with your community colleagues at a meetup.
Support your local user group
November 26, 2025 at 9:45 AM
Absolutely this by @connormcd.bsky.social . Before I started going to user groups I thought I was good at Oracle stuff. But I got so much better when I started going - not just by learning more but also having all these smart friends I could now ask about loads of stuff!
note to self:
when dealing with Property Graphs (whatever blend or flavor) ALWAYS make sure they are ENFORCED.
not on 23ai yet? do the manual work and make sure the PK and FK are in place.
Do NOT start anything until this requirement is fulfilled.
docs.oracle.com/en/database/...
when dealing with Property Graphs (whatever blend or flavor) ALWAYS make sure they are ENFORCED.
not on 23ai yet? do the manual work and make sure the PK and FK are in place.
Do NOT start anything until this requirement is fulfilled.
docs.oracle.com/en/database/...
SQL Language Reference
docs.oracle.com
November 25, 2025 at 9:32 AM
note to self:
when dealing with Property Graphs (whatever blend or flavor) ALWAYS make sure they are ENFORCED.
not on 23ai yet? do the manual work and make sure the PK and FK are in place.
Do NOT start anything until this requirement is fulfilled.
docs.oracle.com/en/database/...
when dealing with Property Graphs (whatever blend or flavor) ALWAYS make sure they are ENFORCED.
not on 23ai yet? do the manual work and make sure the PK and FK are in place.
Do NOT start anything until this requirement is fulfilled.
docs.oracle.com/en/database/...
Reposted by Martin Berger (berx)
It’s frustrating how a bunch of database research from 1980s and before basically doesn’t exist anymore because it’s not on the internet, and it’s not even in the IEEE/ACM indexes of published work.
November 24, 2025 at 8:13 PM
It’s frustrating how a bunch of database research from 1980s and before basically doesn’t exist anymore because it’s not on the internet, and it’s not even in the IEEE/ACM indexes of published work.
Reposted by Martin Berger (berx)
I've just released swingbench 2.8 (#Oracle AI Database load generator). Now with a HTML front end.
You can read all about it here
www.dominicgiles.com/swingbench/2...
You can read all about it here
www.dominicgiles.com/swingbench/2...
November 24, 2025 at 6:57 PM
I've just released swingbench 2.8 (#Oracle AI Database load generator). Now with a HTML front end.
You can read all about it here
www.dominicgiles.com/swingbench/2...
You can read all about it here
www.dominicgiles.com/swingbench/2...
Reposted by Martin Berger (berx)
Next interesting topic.
November 20, 2025 at 7:58 AM
Next interesting topic.
Reposted by Martin Berger (berx)
Excellent turnout for a 5:30PM session at #DOAG25 about #SQLAssertions - with @alexnuijten.bsky.social
November 19, 2025 at 5:25 PM
Excellent turnout for a 5:30PM session at #DOAG25 about #SQLAssertions - with @alexnuijten.bsky.social
Reposted by Martin Berger (berx)
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 ( )
)
@toonkoppelaars.bsky.social explains at #DOAG2025
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS (
)
@toonkoppelaars.bsky.social explains at #DOAG2025
November 19, 2025 at 8:23 AM
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 ( )
)
@toonkoppelaars.bsky.social explains at #DOAG2025
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS (
)
@toonkoppelaars.bsky.social explains at #DOAG2025
Reposted by Martin Berger (berx)
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.
November 16, 2025 at 8:27 PM
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.
Reposted by Martin Berger (berx)
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
November 9, 2025 at 6:17 PM
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
Reposted by Martin Berger (berx)
From the vault. Those pesky dates as strings. https://connor-mcdonald.com/2016/05/13/those-pesky-dates-as-strings
November 5, 2025 at 6:08 PM
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...
)
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...
)
blogs.oracle.com
November 5, 2025 at 10:31 AM
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...
)
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...
)
Reposted by Martin Berger (berx)
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.
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.
November 1, 2025 at 12:38 PM
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.
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)
(SQL Monitor Report does not always show the full beginning of the SQL_IDs parsing)
October 30, 2025 at 8:41 AM
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)
(SQL Monitor Report does not always show the full beginning of the SQL_IDs parsing)
next level: SQL_Optimizer trace?
October 27, 2025 at 8:02 PM
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 ....
October 27, 2025 at 7:59 PM
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...
¯\_(ツ)_/¯
Logical SQL Reference Guide for Oracle Business Intelligence Enterprise Edition
docs.oracle.com/middleware/1...
¯\_(ツ)_/¯
docs.oracle.com
October 22, 2025 at 8:11 AM
Things I never thought I would ever read - today:
Logical SQL Reference Guide for Oracle Business Intelligence Enterprise Edition
docs.oracle.com/middleware/1...
¯\_(ツ)_/¯
Logical SQL Reference Guide for Oracle Business Intelligence Enterprise Edition
docs.oracle.com/middleware/1...
¯\_(ツ)_/¯
Reposted by Martin Berger (berx)
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.
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
October 15, 2025 at 3:36 PM
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.
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 )
the time you gain by faster typing you loose by searching for typos.
(no, they do not need to care about _JAVA_OPtIONS )
October 2, 2025 at 1:21 PM
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 )
the time you gain by faster typing you loose by searching for typos.
(no, they do not need to care about _JAVA_OPtIONS )
Reposted by Martin Berger (berx)
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-...
📄 Paper: db.cs.cmu.edu/papers/2025/...
📁 Code: github.com/future-file-...
October 1, 2025 at 1:49 PM
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-...
📄 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
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
October 1, 2025 at 8:34 AM
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
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.
COLUMN IN ('bla', 'yadda', NULL)
will NOT do what you might had intended.
September 19, 2025 at 11:34 AM
no, the last element in the filter
COLUMN IN ('bla', 'yadda', NULL)
will NOT do what you might had intended.
COLUMN IN ('bla', 'yadda', NULL)
will NOT do what you might had intended.
Reposted by Martin Berger (berx)
Out of The Queue Comes ... Amdahl’s Law!
www.perfdynamics.com/Papers/amdsy...
www.perfdynamics.com/Papers/amdsy...
September 18, 2025 at 5:10 PM
Out of The Queue Comes ... Amdahl’s Law!
www.perfdynamics.com/Papers/amdsy...
www.perfdynamics.com/Papers/amdsy...
Reposted by Martin Berger (berx)
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/
September 17, 2025 at 6:08 PM
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/
Reposted by Martin Berger (berx)
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...
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
September 17, 2025 at 3:34 PM
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...
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...