001internals
Dbvisit Zero Data Loss internals
Inside Dbvisit ZDL: redo-header checks, sequence tracking, full-file bootstrap, block-range transfers and in-place patches on the standby.
13 MIN READRead the field notes ↗
STRAIGHT FROM THE LAB.
READ BETWEEN
THE BYTES._
Oracle internals. Performance. Security.
Real experiments, broken assumptions and the code
that explains what happens underneath.
ora600@lab:~/field-notes⌘
❯ cat /proc/ora600/mindset
____ ____ _ __ ___ ___
/ __ \/ __ \ / \ / / / _ \ / _ \
/ / / / /_/ / / _ \ / /_ | | | | | | |
/ /_/ / _, _/ / ___ \ | '_ \| |_| | |_| |
\____/_/ |_|/_/ \_\ \___/ \___/ \___/[ OK ] question the obvious
[ OK ] trace it to the source
[ OK ] show the evidence
❯ ./go-deeper --no-bullshit▌
120 FIELD NOTES LOADEDMODE: DEEP DIVE
THE LATEST DISPATCHES
Fresh from the lab.
120 field notes / page 1 of 10
002tuning
Two Ways to Count a Full Table Scan
Follow table scan rows gotten through Oracle, GDB and RICO2. Compare row-by-row and block accounting, deleted row flags and the effect of SQL*Plus ARRAYSIZE.
13 MIN READRead the field notes ↗
003tips&tricks
ALIS + Ansible: Oracle patching from a plan to a playbook
Export an Ansible patching bundle from ALIS, prepare a new Oracle Home and patch a database with AutoUpgrade. A practical walkthrough with a real Oracle 19.23 to 19.32 lab run.
11 MIN READRead the field notes ↗
004tips&tricks
ALIS — AutoUpgrade Looks Insanely Simple
Meet ALIS: an Oracle AutoUpgrade workbench that turns your plan into a configuration and an ordered runbook. Runs locally in your browser, with an offline edition and editable examples.
6 MIN READRead the field notes ↗
005Oracle
nls_territory and weird reason in v$sql_shared_cursor
One of my customers experienced a weird behavior – thousands of child cursors with LANGUAGE_MISMATCH When I looked closer, into V$SQL_SHARED_CURSOR.REASON I saw something puzzling: While this part is normal: Be
8 MIN READRead the field notes ↗
006Oracle
Noisy neighbors – Oracle latches and multitenant
A year ago I described the basics of checkpoint queue latches: After writing that article, I attended an excellent lecture by Mike Dietrich and Daniel Overby Hansen about noisy neighbors in a multitenant enviro
8 MIN READRead the field notes ↗
007Oracle
JAS-MIN and AI
I know, I know – AI is stupid… but we shouldn’t be and LLM is a tool that we should get familiar with. That’s why JAS-MIN gets integration with AI in two modes – one-time batch processing and backend assistant.
5 MIN READRead the field notes ↗
008Oracle
Simulate Oracle Cloud on KVM/OLVM
We have no idea when Oracle 23ai will be released on premises. And it is a shame, since this database is offering a lot of great features that you probably would like to learn! One of the solutions is to use Or
2 MIN READRead the field notes ↗
009Oracle
RICO3 – as a tool for thief
I know I know, it’s getting boring when I constantly talk and write about an evil KVM admin, but tomorrow starts our first meetup with IBM and they are going to explain why my hacks won’t work in Power environm
4 MIN READRead the field notes ↗
010Oracle
JAS-MIN
Not having Diagnostic Pack sucks. But event if you have it, it is not that obvious that you will be able to visualize properly the data and perform a meaningful analyze. That’s why I have created JAS-MIN! A lit
10 MIN READRead the field notes ↗
011Oracle
When security drives you crazy! (CBFUK)
More and more customers are using fancy security tools like CyberArk or other solutions based on Windows RDP with turned off or limited possibility of copy/paste functionalities. And I get it. Security is reall
3 MIN READRead the field notes ↗
012Oracle
How checkpoint queue actually works (the basic scenario)
This article is true for Oracle 19.19 and 19.23 on ARM. On x86_64 there’s something funny going on with location of the buffer address in the private memory (finding appropriate register at kcbklbc call)- I nee
8 MIN READRead the field notes ↗