Martin Berger

SQL> alter system flush shared_poool; alter system flush shared_poool * ERROR at line 1:

when my shared poool isn't as large as I'd expected ...

I still try to get used to all the " yes, but ... In reality ... "

What do you expect?
It's there & working.
Why to rename it just when a little detail changes?
(You could blame the initial naming for short sight)

" ... I simplified explanations more than it's good for this specific case ..."
should still fit onto a slide?

YouTube video by Oracle Database Upgrades and Migrations Unique Learning Experience at Oracle CloudWorld 2025

⚠️Don’t miss a one-of-a-kind learning opportunity at Oracle CloudWorld 2025 ⚠️

www.youtube.com/watch?v=Mbi4...

@mikedietrichde.com
@dohdatabase.com
@dbarj.com.br

Do you have some information how the "average household" changed?
In m^2, weekly vacations, number of washing machine, TV, mobiles, ...
I always suspect we consume much more than in 1965, but good data is hard to get.

Please.... if you're vibe coding something up, make it secure

Nice to see a public presentation about SQL Assertions by @toonkoppelaars.bsky.social at @doagev.bsky.social
my.doag.org/events/userc...

Example defining annotations on a table and column in Oracle Database 19.28

With all the new stuff in the 23ai RUs, it can be easy to overlook some cool changes in 19c such as

Schema annotations have been backported to 19.28

These enable you to add key-value metadata to describe tables, columns, and other database objects

How COBOL Defeated the Coup USA

The military failed. The courts flinched. But 60-year-old code saved democracy.

This weekend, why not check out the ACE program?
@oracleace.bsky.social
ace.oracle.com

My friend's kid is doing a Masters in Economics. She needs people to fill in this anonymous survey. It takes about 10 minutes to complete. If you have a few minutes, it would be cool if you could help her.

docs.google.com/forms/d/e/1F...

for those who want to see all changes in greater detail, oradiff.oracle.com is the source of truth!
My top "little gem" in 23.9:
COMPATIBLE is now ISINSTANCE_MODIFIABLE => TRUE

note to self update:
if unsure if the column is stored as LOB (e.g. extended VARCHAR2), don't go for COL$.property - use ALL_LOBS instead.
(it's so much easier)

Official announcement/introduction to our MCP Server for Oracle Database

blogs.oracle.com/database/pos...

Oracle Enterprise Manager has a new AI-powered sibling. Hype? Hope? Or the real deal?

Join @julianfrey.ch at the #POUG2025, as he puts EM 24ai under the microscope.
poug.org/en/edycja/po...

note to self:
don't be confused by
DIRECT PATH READ|WRITE for a Single Row
UPDATE <table> SET <c1> = :1 , <c2> = :2 WHERE <pk> = :3
...
keep LOBs in mind, and everything makes sense.

Note to self:
when analyzing AWR dumps from CDB-level,
DBA_HIST_PDB_INSTANCE let me map CON_DBID to PDB_NAME.

this meme stolen from nixCraft.. but I can relate.

Components in library RDBMS: -------------------------- SQL_Compiler SQL Compiler ((null)) SQL_Parser SQL Parser (qcs) SQL_Semantic SQL Semantic Analysis (kkm) SQL_Optimizer SQL Optimizer ((null)) SQL_Code_Generator SQL Code Generator (qka, qkn, qke, kkfd, qkx)

I refer to
alter session set events 'trace[ SQL_Code_Generator.*] ';

there isn't a lot available on the open internet.
Together with SQL_Optimizer (and others) ot belongs to SQL_Compiler.

getting bored reading SQL_Optimizer traces?
give SQL_Code_Generator a try!
🤯

Isn't the real fun phrasing the requirement?
I feel translating it into SQL the easy part.

Couple of additions to the blog post with a bit more insight into what is taking place, and some insight and guesswork into how the timeout works.

Access Denied You don't have permission to access "http://qwww.americanexpress.com/" on this server. Reference #18.95071002.1750228303.3ff7a4b https://errors.edgesuite.net/18.95071002.1750228303.3ff7a4b

QA: "let's see if the customer can spot it"
🤦‍♂️
@americanexpress.bsky.social

• Micro-scopic aspects – block internals - (Relative) database block address (R)DBA - 4 bytes - 10 bits for the (relative) file# - 210 -1 = 1023 - in oracle7 some wrapping applies for backwards compatibility with Oracle6 - usually 8/2 split wrapping

when following NRIDs for chained rows, it can be hard to identify the next block.
This piece might be "good enough" for many cases.
www.nyoug.org/Presentation...

@brendan-tierney.bsky.social building a AI agent on Oracle Cloud Infrastructure to answer questions about Shakespeare

This could help students prepare for exam on Shakespeare by giving example answers to past questions

#AOUG25

1/10
The log parallelism feature has been part of Oracle since 9i (20+ years or so), but surprisingly, there's not much information available on how it really works. Time for a closer look ... 👇

This is the last day to submit for

ConTech 2025.

CfP ends TODAY!
So head to https://www.papercall.io/contechbyrooug2025 now and submit.

@Mirela_RoOUG #ConTech25

See all Events and CfPs on www.clocwise.org.

DETERMINISTIC is probably a good choice.
think about the function being called in the WHERE clause changes over time for huge data set.
(that's the origin of this simplified testcase)

LEVEL SYSDATE MY_SYSDATE ---------- ------------------- ------------------- 1 2025-06-05 06:58:10 2025-06-05 06:58:11 2 2025-06-05 06:58:10 2025-06-05 06:58:12 3 2025-06-05 06:58:10 2025-06-05 06:58:13 4 2025-06-05 06:58:10 2025-06-05 06:58:14 5 2025-06-05 06:58:10 2025-06-05 06:58:15 6 2025-06-05 06:58:10 2025-06-05 06:58:16 7 2025-06-05 06:58:10 2025-06-05 06:58:17 8 2025-06-05 06:58:10 2025-06-05 06:58:18 9 2025-06-05 06:58:10 2025-06-05 06:58:19

some fun with sysdate:
SELECT level, sysdate, my_sysdate
FROM dual
connect by level < 10;

L SYSDATE MY_SYSDATE
- ------------------- ----------
1 2025-06-05 06:58:10 2025-06-05 06:58:11
2 2025-06-05 06:58:10 2025-06-05 06:58:12
3 2025-06-05 06:58:10 2025-06-05 06:58:13
...