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)
Big milestone today! ‼️
We have officially opened the #Oracle #ACEApprentice program! 🎉 🎉 🎉
Never was learning to be an advocate so much fun! 🧑🎓
We have officially opened the #Oracle #ACEApprentice program! 🎉 🎉 🎉
Never was learning to be an advocate so much fun! 🧑🎓
🎉 We’re live! The #OracleACE Apprentice program is officially open—welcome to everyone who pre-registered (check your inbox soon!) and all new applicants.
Ready to start your advocacy journey? Learn more & register here 👉
ace.oracle.com/apprentice
Ready to start your advocacy journey? Learn more & register here 👉
ace.oracle.com/apprentice
December 8, 2025 at 6:00 PM
Big milestone today! ‼️
We have officially opened the #Oracle #ACEApprentice program! 🎉 🎉 🎉
Never was learning to be an advocate so much fun! 🧑🎓
We have officially opened the #Oracle #ACEApprentice program! 🎉 🎉 🎉
Never was learning to be an advocate so much fun! 🧑🎓
Reposted by Martin Berger (berx)
Nice new modern look to MOS
December 7, 2025 at 11:59 PM
Nice new modern look to MOS
Reposted by Martin Berger (berx)
Want to see all the Oracle tech diagrams in one place? It's here in the docs
docs.oracle.com/en/database/...
HT Kevin
docs.oracle.com/en/database/...
HT Kevin
December 8, 2025 at 2:21 AM
Want to see all the Oracle tech diagrams in one place? It's here in the docs
docs.oracle.com/en/database/...
HT Kevin
docs.oracle.com/en/database/...
HT Kevin
Reposted by Martin Berger (berx)
Sometimes life knocks you off your sled just to remind you who’s actually steering. #CalvinandHobbes #SnowDayChaos
December 8, 2025 at 6:00 AM
Sometimes life knocks you off your sled just to remind you who’s actually steering. #CalvinandHobbes #SnowDayChaos
note to self:
Usage Tracking is a standard feature in OBIEE / OAS / OAC.
Never start any perf. analysis without this enabled & configured ( & proper access to it).
Usage Tracking is a standard feature in OBIEE / OAS / OAC.
Never start any perf. analysis without this enabled & configured ( & proper access to it).
December 5, 2025 at 12:36 PM
note to self:
Usage Tracking is a standard feature in OBIEE / OAS / OAC.
Never start any perf. analysis without this enabled & configured ( & proper access to it).
Usage Tracking is a standard feature in OBIEE / OAS / OAC.
Never start any perf. analysis without this enabled & configured ( & proper access to it).
Reposted by Martin Berger (berx)
🎉🎉🎉 Big news today and perhaps an early Christmas present.
👉 #Oracle AI #Database #26ai is coming soon for Linux x86-64 on-premises: blogs.oracle.com/database/ora...
👉 #Oracle AI #Database #26ai is coming soon for Linux x86-64 on-premises: blogs.oracle.com/database/ora...
December 3, 2025 at 5:25 PM
🎉🎉🎉 Big news today and perhaps an early Christmas present.
👉 #Oracle AI #Database #26ai is coming soon for Linux x86-64 on-premises: blogs.oracle.com/database/ora...
👉 #Oracle AI #Database #26ai is coming soon for Linux x86-64 on-premises: blogs.oracle.com/database/ora...
Reposted by Martin Berger (berx)
Merry christmas to all dba's🎉😉
December 3, 2025 at 7:59 AM
Merry christmas to all dba's🎉😉
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.