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
Oracle
118 field notes / page 1 of 10
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 ↗
005Oracle
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 ↗
006Oracle
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 ↗
007Oracle
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 ↗
008Oracle
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 ↗
009Oracle
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 ↗
010Oracle
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 ↗
011Oracle
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 ↗
012Oracle
[SOLVED!] ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ
This is a pain in the ass. You try to import something from a newer database and you hit the error that your timestamp is not good enough! Even tho you have no timestamp datatypes in the dump… The whole case wa
5 MIN READRead the field notes ↗