001tuning
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 ↗
BROWSE THE FIELD NOTES
2026
4 field notes / page 1 of 1
002tips&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 ↗
003tips&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 ↗
004Oracle
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 ↗