DBAMarco

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 …

Basics of @oracledatabase.bsky.social 23ai Domains dbamarco.wordpress.com/2025/06/19/o...

There still time 🙂

Still some 1:1 sessions free. You can find the board where the sessions will be held tomorrow, in the exhibition hall “DOME”. #apexconn25

IMP you need the configure a separate dispatcher for that. Per default there’s just one that handles the XDB service.
See docs.oracle.com/en/database/...

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

Dynamic stats for PL/SQL functions (23.8) Improve row estimates for PL/SQL functions in SQL with dynamic stats By default row estimates for pipelined table functions are poor

Dynamic stats for PL/SQL functions (23.8) Improve row estimates for PL/SQL functions in SQL with dynamic stats With dynamic PL/SQL stats in 23.8, get accurate row estimates for pipelined functions

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

Next level safe harbour by @martindba.bsky.social at the opening keynote at #DOAGDB25
@doagev.bsky.social
@oracleace.bsky.social

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? 😃 🙃 🎢 🥳

A nice habit should never end … time for #DOAGrunning again with @dbamarco.bsky.social #DOAGDB25 @oracleace.bsky.social strava.app.link/92p5LSc8lTb

Gonna catch @dbamarco.bsky.social and then head to Rust for #DOAGDB25

There is a MOS Note "Incorrect OCINumberFromReal Conversion (Doc ID 2978992.1)" indicating the issue. I'll check that.

Thanks a lot. That matches my case. I copied the data using CTAS, same behaviour. When I updated the value using round, the value gets "fixed".

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

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…

If smoke isn't coming out of your machine, you aren't really working :-)
connor-mcdonald.com/2025/05/05/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…

New Blog! I think I've changed my mind on optimizer statistics on GTT.
connor-mcdonald.com/2025/05/06/s...

It‘s #doagrunning time again and as always a great pleasure to run with @dbamarco.bsky.social

Really worth catching up on the new Exadata 11 platform.

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…

#Oracle #Database: be careful when modifying datatypes with an default-on-null setting.
dbamarco.wordpress.com/2024/12/12/c...

♠️ 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

Thanks god it was named Sequel: Structured *english* query language.

Drei tolle Tage #DOAG2024. Wir freuen uns auf ein Wiedersehen.

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

I remember the days when even Visual Basic for the macros was in Geeman…. Weird.

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.

Full room for @ludovico.bsky.social at #DOAG2024 talking about #PostgreSQL and if it’s catching up to #Oracle.

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…

Huge News!

Important Update to Oracle Database 19c Support Timelines

mikedietrichde.com/2024/11/20/i...

Last call to join me at #DOAG2024, room Hongkong: #Oracle #ER vs #SE2

@ludovico.bsky.social showing different and new ways to create #Oracle #Dataguard configurations in #23ai at #DOAG2024.