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 ↗
FIELD NOTESTHE ORA-600 BLOGSearch /BROWSE THE FIELD NOTES
2 field notes / page 1 of 1
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.
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.