Christoph Lutz
@christophlutz.bsky.social
Those who don't jump will never fly.
https://www.0xChris.dev
https://www.0xChris.dev
Reposted by Christoph Lutz
Burning tokens for useful toys continues.
I enjoy using SQLcl but if you (like me) use oradebug for testing, investigating and mostly fun, you will be forced to use SQL*Plus.
So I instrumented Codex to create a plugin for SQLcl to call upidbg, kpusvcrh and kpusvc2hst :)
github.com/ora600pl/soda
I enjoy using SQLcl but if you (like me) use oradebug for testing, investigating and mostly fun, you will be forced to use SQL*Plus.
So I instrumented Codex to create a plugin for SQLcl to call upidbg, kpusvcrh and kpusvc2hst :)
github.com/ora600pl/soda
September 23, 2026 at 2:27 PM
Burning tokens for useful toys continues.
I enjoy using SQLcl but if you (like me) use oradebug for testing, investigating and mostly fun, you will be forced to use SQL*Plus.
So I instrumented Codex to create a plugin for SQLcl to call upidbg, kpusvcrh and kpusvc2hst :)
github.com/ora600pl/soda
I enjoy using SQLcl but if you (like me) use oradebug for testing, investigating and mostly fun, you will be forced to use SQL*Plus.
So I instrumented Codex to create a plugin for SQLcl to call upidbg, kpusvcrh and kpusvc2hst :)
github.com/ora600pl/soda
Deobfuscating Local Auto-Login Wallets in Oracle 26ai
Deobfuscating Local Auto-Login Wallets in Oracle 26ai
t.ly
September 15, 2026 at 8:45 AM
Reposted by Christoph Lutz
#POUG2026 is over - post conference blues kicks in.
Thank you @luizafrompoland.bsky.social & @ora600pl.bsky.social and all your team for the fabulous event!
Big thanks to all the speakers and attendees for content, questions & discussions. You all make this conference unique.
See you at #POUG2027
Thank you @luizafrompoland.bsky.social & @ora600pl.bsky.social and all your team for the fabulous event!
Big thanks to all the speakers and attendees for content, questions & discussions. You all make this conference unique.
See you at #POUG2027
September 6, 2026 at 4:50 PM
#POUG2026 is over - post conference blues kicks in.
Thank you @luizafrompoland.bsky.social & @ora600pl.bsky.social and all your team for the fabulous event!
Big thanks to all the speakers and attendees for content, questions & discussions. You all make this conference unique.
See you at #POUG2027
Thank you @luizafrompoland.bsky.social & @ora600pl.bsky.social and all your team for the fabulous event!
Big thanks to all the speakers and attendees for content, questions & discussions. You all make this conference unique.
See you at #POUG2027
Reposted by Christoph Lutz
Some „basics“ about log writer (LGWR) explained by @christophlutz.bsky.social at #POUG2026, including a live demo with foreground session @franckpachot.bsky.social and log writer @chandlerdba.bsky.social
September 5, 2026 at 10:08 AM
Some „basics“ about log writer (LGWR) explained by @christophlutz.bsky.social at #POUG2026, including a live demo with foreground session @franckpachot.bsky.social and log writer @chandlerdba.bsky.social
In Oracle 26ai, auto-login wallets are protected by a randomly generated password encrypted with a random 128-bit AES key.
Both are stored in the cwallet.sso header, allowing the original ewallet.p12 and its TDE master key to be recovered.
Full details: t.ly/hfZXS
Both are stored in the cwallet.sso header, allowing the original ewallet.p12 and its TDE master key to be recovered.
Full details: t.ly/hfZXS
Deobfuscating Auto-Login Wallets in Oracle 26ai
Deobfuscating Auto-Login Wallets in Oracle 26ai (cwallet.sso)
t.ly
September 1, 2026 at 9:27 AM
In Oracle 26ai, auto-login wallets are protected by a randomly generated password encrypted with a random 128-bit AES key.
Both are stored in the cwallet.sso header, allowing the original ewallet.p12 and its TDE master key to be recovered.
Full details: t.ly/hfZXS
Both are stored in the cwallet.sso header, allowing the original ewallet.p12 and its TDE master key to be recovered.
Full details: t.ly/hfZXS
The DBMS_CREDENTIAL.CREATE_CREDENTIAL procedure obfuscates passwords by encrypting them with a randomly generated AES-128 key.
The encrypted password and its encryption key are then base64 encoded and stored in the data dictionary.
Full details: t.ly/mp5bB
The encrypted password and its encryption key are then base64 encoded and stored in the data dictionary.
Full details: t.ly/mp5bB
Deobfuscating Oracle Credential Passwords
Deobfuscating Oracle Credentials Passwords (dbms_credential)
t.ly
August 11, 2026 at 9:14 AM
The DBMS_CREDENTIAL.CREATE_CREDENTIAL procedure obfuscates passwords by encrypting them with a randomly generated AES-128 key.
The encrypted password and its encryption key are then base64 encoded and stored in the data dictionary.
Full details: t.ly/mp5bB
The encrypted password and its encryption key are then base64 encoded and stored in the data dictionary.
Full details: t.ly/mp5bB
Had a closer look at the implementation of the CURSORTRACE event... and encountered a few surprises:
t.ly/jQG6B
t.ly/jQG6B
Understanding the CURSORTRACE Event
The Oracle library cache is extensively instrumented, but the instrumentation is disabled by default. It can be enabled using the CURSORTRACE event, which is particularly useful for investigating libr...
t.ly
July 31, 2026 at 1:06 PM
Had a closer look at the implementation of the CURSORTRACE event... and encountered a few surprises:
t.ly/jQG6B
t.ly/jQG6B
Undocumented SYS_CONTEXT Parameters
Undocumented SYS_CONTEXT Parameters
t.ly
July 15, 2026 at 10:09 AM
Restricted and Undocumented oradebug Commands
Restricted and Undocumented oradebug Commands
t.ly
June 3, 2026 at 8:44 AM
The greatest DBA tool of all time is gdb - change my mind.
June 1, 2026 at 9:59 AM
The greatest DBA tool of all time is gdb - change my mind.
A little script and some background information on how to extract v$ definitions directly from the oracle binary.
t.ly/NT6L7
t.ly/NT6L7
Extracting Fixed View Definitions From The Oracle Binary
Extracing Fixed View Definitions From The Oracle Binary
t.ly
May 19, 2026 at 8:53 AM
A little script and some background information on how to extract v$ definitions directly from the oracle binary.
t.ly/NT6L7
t.ly/NT6L7
Reposted by Christoph Lutz
Avelio is live! 🚀
We are your Swiss partner for Oracle on‑premises database operations.
Our mission: Optimised. Automated. Always Available.
From proactive monitoring to 24/7 SLA‑backed support.
Your business deserves reliability.
Find out more: avelio.ch
#Oracle #DatabaseManagement
We are your Swiss partner for Oracle on‑premises database operations.
Our mission: Optimised. Automated. Always Available.
From proactive monitoring to 24/7 SLA‑backed support.
Your business deserves reliability.
Find out more: avelio.ch
#Oracle #DatabaseManagement
May 13, 2026 at 8:10 AM
Avelio is live! 🚀
We are your Swiss partner for Oracle on‑premises database operations.
Our mission: Optimised. Automated. Always Available.
From proactive monitoring to 24/7 SLA‑backed support.
Your business deserves reliability.
Find out more: avelio.ch
#Oracle #DatabaseManagement
We are your Swiss partner for Oracle on‑premises database operations.
Our mission: Optimised. Automated. Always Available.
From proactive monitoring to 24/7 SLA‑backed support.
Your business deserves reliability.
Find out more: avelio.ch
#Oracle #DatabaseManagement
1/2
Interesting and undocumented changes in SGA management in Oracle 26ai:
- Up to 31 subpools in the shared pool (max seven in 19c defined by _kghdsidx_count)
- Subpools are split into thee durations (there were only two in 19c)
Interesting and undocumented changes in SGA management in Oracle 26ai:
- Up to 31 subpools in the shared pool (max seven in 19c defined by _kghdsidx_count)
- Subpools are split into thee durations (there were only two in 19c)
April 20, 2026 at 9:19 PM
1/2
Interesting and undocumented changes in SGA management in Oracle 26ai:
- Up to 31 subpools in the shared pool (max seven in 19c defined by _kghdsidx_count)
- Subpools are split into thee durations (there were only two in 19c)
Interesting and undocumented changes in SGA management in Oracle 26ai:
- Up to 31 subpools in the shared pool (max seven in 19c defined by _kghdsidx_count)
- Subpools are split into thee durations (there were only two in 19c)
Pipelined or parallel? In Adaptive Scalable mode LGWR can assign redo writes to worker processes in different ways. More details in the post below 👇
t.ly/HJi5d
t.ly/HJi5d
Adaptive Scalable LGWR Pipelined vs Parallel Redo Writes
An earlier post explained the decision-making heuristics when LGWR transitions from single to scalable mode. Here, we examine how it handles redo writes in scalable mode with multiple LG worker proces...
t.ly
March 18, 2026 at 9:12 AM
Pipelined or parallel? In Adaptive Scalable mode LGWR can assign redo writes to worker processes in different ways. More details in the post below 👇
t.ly/HJi5d
t.ly/HJi5d
Everybody should get rid of tnsnames.ora and use Easy Connect instead. Change my mind.
February 13, 2026 at 8:49 PM
Everybody should get rid of tnsnames.ora and use Easy Connect instead. Change my mind.
Just discovered this new blog series by @ludovico.bsky.social explaining Data Guard enhancements in 26ai - must read👇
www.ludovicocaldara.net/dba/dg-26ai-...
www.ludovicocaldara.net/dba/dg-26ai-...
Mini-blog series: Oracle Data Guard 26ai new features
Oracle AI Database 26ai is here for Linux x86_64—packed with new features for Data Guard! Stay tuned for quick blog posts on key changes.
www.ludovicocaldara.net
February 10, 2026 at 3:53 AM
Just discovered this new blog series by @ludovico.bsky.social explaining Data Guard enhancements in 26ai - must read👇
www.ludovicocaldara.net/dba/dg-26ai-...
www.ludovicocaldara.net/dba/dg-26ai-...