DBAMarco
@dbamarco.bsky.social
Oracle addicted for two decades and counting | ACE Pro | nature friend
Basics of @oracledatabase.bsky.social 23ai Domains dbamarco.wordpress.com/2025/06/19/o...
Oracle 23ai: Domains #1
Finally I continue my series of posts about my favorite Oracle Database 23ai new features. Quite some time passed by sine the first post in this series, I was and still am very busy the last weeks …
dbamarco.wordpress.com
June 19, 2025 at 1:54 PM
Basics of @oracledatabase.bsky.social 23ai Domains dbamarco.wordpress.com/2025/06/19/o...
There still time 🙂
#DOAG2025: Der Call for Papers für die DOAG 2025 Konferenz + Ausstellung ist noch bis Dienstag, den 3. Juni geöffnet! Reicht euren Abstract ein! ➡️ scomp.ly/98jbdJl
June 2, 2025 at 10:53 AM
There still time 🙂
Reposted by DBAMarco
Still some 1:1 sessions free. You can find the board where the sessions will be held tomorrow, in the exhibition hall “DOME”. #apexconn25
May 14, 2025 at 11:17 AM
Still some 1:1 sessions free. You can find the board where the sessions will be held tomorrow, in the exhibition hall “DOME”. #apexconn25
Reposted by DBAMarco
Windows or Linux ... we got your latest 23ai Free release right here for you
May 14, 2025 at 2:58 PM
Windows or Linux ... we got your latest 23ai Free release right here for you
@isdba.de and Tom Fels from @technologie.robotron.services explaining #AI #vectorsearch running on #OracleODA at #DOAGDB25
@doagev.bsky.social
@doagev.bsky.social
May 14, 2025 at 10:14 AM
@isdba.de and Tom Fels from @technologie.robotron.services explaining #AI #vectorsearch running on #OracleODA at #DOAGDB25
@doagev.bsky.social
@doagev.bsky.social
Reposted by DBAMarco
Oracle Database Free 23.8 is now available
Get it at
www.oracle.com/database/fre...
This has a neat tweak if you're getting poor row estimates for PL/SQL in SQL:
Enhanced dynamic stats for PL/SQL in FROM & WHERE
This can be particularly useful for estimating pipelined table functions
Get it at
www.oracle.com/database/fre...
This has a neat tweak if you're getting poor row estimates for PL/SQL in SQL:
Enhanced dynamic stats for PL/SQL in FROM & WHERE
This can be particularly useful for estimating pipelined table functions
May 13, 2025 at 3:01 PM
Oracle Database Free 23.8 is now available
Get it at
www.oracle.com/database/fre...
This has a neat tweak if you're getting poor row estimates for PL/SQL in SQL:
Enhanced dynamic stats for PL/SQL in FROM & WHERE
This can be particularly useful for estimating pipelined table functions
Get it at
www.oracle.com/database/fre...
This has a neat tweak if you're getting poor row estimates for PL/SQL in SQL:
Enhanced dynamic stats for PL/SQL in FROM & WHERE
This can be particularly useful for estimating pipelined table functions
Next level safe harbour by @martindba.bsky.social at the opening keynote at #DOAGDB25
@doagev.bsky.social
@oracleace.bsky.social
@doagev.bsky.social
@oracleace.bsky.social
May 14, 2025 at 8:08 AM
Next level safe harbour by @martindba.bsky.social at the opening keynote at #DOAGDB25
@doagev.bsky.social
@oracleace.bsky.social
@doagev.bsky.social
@oracleace.bsky.social
Reposted by DBAMarco
Vorschau: Morgen, von 19 bis 21 Uhr, sind während der Dinner- & DJ-Party 3 Fahrgeschäfte für die Teilnehmenden der #apexconn25 und #DOAGDB25 ‚geblockt‘ — die genauen Fahrzeiten stehen auch in unserer Parkplan-Grafik, oben rechts ➡️ www.doag.org/fileadmin/Ev.... Wer macht mit? 😃 🙃 🎢 🥳
May 13, 2025 at 12:20 PM
Vorschau: Morgen, von 19 bis 21 Uhr, sind während der Dinner- & DJ-Party 3 Fahrgeschäfte für die Teilnehmenden der #apexconn25 und #DOAGDB25 ‚geblockt‘ — die genauen Fahrzeiten stehen auch in unserer Parkplan-Grafik, oben rechts ➡️ www.doag.org/fileadmin/Ev.... Wer macht mit? 😃 🙃 🎢 🥳
Reposted by DBAMarco
A nice habit should never end … time for #DOAGrunning again with @dbamarco.bsky.social #DOAGDB25 @oracleace.bsky.social strava.app.link/92p5LSc8lTb
May 14, 2025 at 6:13 AM
A nice habit should never end … time for #DOAGrunning again with @dbamarco.bsky.social #DOAGDB25 @oracleace.bsky.social strava.app.link/92p5LSc8lTb
Reposted by DBAMarco
Gonna catch @dbamarco.bsky.social and then head to Rust for #DOAGDB25
May 13, 2025 at 7:16 AM
Gonna catch @dbamarco.bsky.social and then head to Rust for #DOAGDB25
What's wrong with my #Oracle SQLplus? #SQLcl works just fine. And why does the "to_char" return an error? I'm confused. /cc @oracleace.bsky.social
May 8, 2025 at 7:24 AM
What's wrong with my #Oracle SQLplus? #SQLcl works just fine. And why does the "to_char" return an error? I'm confused. /cc @oracleace.bsky.social
Reposted by DBAMarco
If smoke isn't coming out of your machine, you aren't really working :-)
connor-mcdonald.com/2025/05/05/s...
connor-mcdonald.com/2025/05/05/s...
Smashing a database on my PC
Colleague Martin Berger posted this recentlyand it got me thinking: If we take out the network (by running a program locally on the database server) how many requests per second can a modern but af…
connor-mcdonald.com
May 5, 2025 at 1:16 PM
If smoke isn't coming out of your machine, you aren't really working :-)
connor-mcdonald.com/2025/05/05/s...
connor-mcdonald.com/2025/05/05/s...
Reposted by DBAMarco
New Blog! I think I've changed my mind on optimizer statistics on GTT.
connor-mcdonald.com/2025/05/06/s...
connor-mcdonald.com/2025/05/06/s...
Statistics on Global Temporary Tables
Something I’ve been seeing lately is a strategy of not collecting statistics on global temporary tables. The philosophy makes sense since typically global temporary tables (GTTs) are populate…
connor-mcdonald.com
May 6, 2025 at 6:05 AM
New Blog! I think I've changed my mind on optimizer statistics on GTT.
connor-mcdonald.com/2025/05/06/s...
connor-mcdonald.com/2025/05/06/s...
Reposted by DBAMarco
It‘s #doagrunning time again and as always a great pleasure to run with @dbamarco.bsky.social
April 4, 2025 at 7:01 AM
It‘s #doagrunning time again and as always a great pleasure to run with @dbamarco.bsky.social
Reposted by DBAMarco
Really worth catching up on the new Exadata 11 platform.
Join Kothanda Umamageswaran and Bob Thome on January 7 for the announcement of the newest @OracleExadata X11M system, delivering extreme performance for AI, OLTP, and analytics. Register at 👇https://www.linkedin.com/events/oracleexadata-next-generationin7280643074777563136/theater/
Oracle Exadata: Next-Generation Intelligent Data Architecture | LinkedIn
Join Kothanda Umamageswaran, SVP of Exadata and Scale-Out Technologies and Bob Thome, VP of Exadata Product Management for the announcement of the newest Oracle Exadata system delivering extreme perfo...
www.linkedin.com
January 7, 2025 at 3:45 PM
Really worth catching up on the new Exadata 11 platform.
#Oracle #Database: be careful when modifying datatypes with an default-on-null setting.
dbamarco.wordpress.com/2024/12/12/c...
dbamarco.wordpress.com/2024/12/12/c...
Caveat with default-on-null when modifying the datatype
During a recent UTF8 migration project, a colleague stumbled upon an issue regarding NOT NULL constraints. They where using the Database Migration Assistant for Unicode (DMU) to convert the content…
dbamarco.wordpress.com
December 12, 2024 at 2:31 PM
#Oracle #Database: be careful when modifying datatypes with an default-on-null setting.
dbamarco.wordpress.com/2024/12/12/c...
dbamarco.wordpress.com/2024/12/12/c...
Reposted by DBAMarco
♠️ We are happy to invite you to the first Oracle ACE Virtual Conference! Join us on December 11 and learn from amazing ACE speakers. 👉
Book your FREE spot now 👉
asktom.oracle.com/ords/r/tech/...
#OracleACE
Book your FREE spot now 👉
asktom.oracle.com/ords/r/tech/...
#OracleACE
December 5, 2024 at 6:21 PM
♠️ We are happy to invite you to the first Oracle ACE Virtual Conference! Join us on December 11 and learn from amazing ACE speakers. 👉
Book your FREE spot now 👉
asktom.oracle.com/ords/r/tech/...
#OracleACE
Book your FREE spot now 👉
asktom.oracle.com/ords/r/tech/...
#OracleACE
Reposted by DBAMarco
It should be an obvious recommendation, but some customers still use old versions of Oracle databases
@chandlerdba.bsky.social talks about Unified Audit at #DOAG2024
@chandlerdba.bsky.social talks about Unified Audit at #DOAG2024
November 21, 2024 at 1:09 PM
It should be an obvious recommendation, but some customers still use old versions of Oracle databases
@chandlerdba.bsky.social talks about Unified Audit at #DOAG2024
@chandlerdba.bsky.social talks about Unified Audit at #DOAG2024
Reposted by DBAMarco
It‘s a streak! Started active into last day of #doag2024 and thanks to my colleagues @dbamarco.bsky.social and Thomas for pushing me, it was a joy 🏃♂️ #doagrunning
November 21, 2024 at 8:22 AM
It‘s a streak! Started active into last day of #doag2024 and thanks to my colleagues @dbamarco.bsky.social and Thomas for pushing me, it was a joy 🏃♂️ #doagrunning
Today at 10am at #DOAG2024: an introduction to the #oracleace program. If you’re interested, just come around.
November 21, 2024 at 8:21 AM
Today at 10am at #DOAG2024: an introduction to the #oracleace program. If you’re interested, just come around.
Full room for @ludovico.bsky.social at #DOAG2024 talking about #PostgreSQL and if it’s catching up to #Oracle.
November 20, 2024 at 2:32 PM
Full room for @ludovico.bsky.social at #DOAG2024 talking about #PostgreSQL and if it’s catching up to #Oracle.
Reposted by DBAMarco
Huge News!
Important Update to Oracle Database 19c Support Timelines
mikedietrichde.com/2024/11/20/i...
Important Update to Oracle Database 19c Support Timelines
mikedietrichde.com/2024/11/20/i...
Important Update to Oracle Database 19c Support Timelines
Long silence doesn’t mean that I am hiding. It just means that it’s very busy right now. And hopefully with less travel I will have more time to blog and reply also to your comments. St…
mikedietrichde.com
November 20, 2024 at 8:54 AM
Huge News!
Important Update to Oracle Database 19c Support Timelines
mikedietrichde.com/2024/11/20/i...
Important Update to Oracle Database 19c Support Timelines
mikedietrichde.com/2024/11/20/i...
@ludovico.bsky.social showing different and new ways to create #Oracle #Dataguard configurations in #23ai at #DOAG2024.
November 19, 2024 at 3:21 PM
@ludovico.bsky.social showing different and new ways to create #Oracle #Dataguard configurations in #23ai at #DOAG2024.