Checking Free Space of UNDO Tablespaces
Introduction This blog is a high-level overview of the fundamental Oracle feature UNDO tablespace...
Pythian Blog: Data Analytics, Cloud Computing, and Database Management | Timur Akhmadeev
Slow query to V$ views after DBRU Patching
One of our clients patched its EBS database 19.13 to DBRU 19.17 and faced an issue with one of the...
Identifying the Root Cause of High CPU Usage by e-Business Suite R12.2 OA Core server processes
A new client was experiencing regular issues with its OA Core servers on its EBS 12.2 environment....
Slow Query in eBS AutoConfig with DB 19c
We recently completed a few e eBS R12.2 database upgrade installations and noticed an issue with a...
Two Cases of Troubleshooting with psn
No, it’s not the PlayStation Network! Linux Process Snapper — pSnapper, or psn — is an open source...
Migrating btrfs root partition to ext4 in OVM
Recently I spent some time trying to migrate root partition to another FS type in an OVM...
How to fix the skip scan bug in 18c
A recent Twitter thread had an interesting test case of the optimizer choosing sub-optimal skip...
Inefficient queries to ALL_SYNONYMS
Short summary: Queries to ALL_SYNONYMS cause FTS of SYS.OBJ$ which can't be avoided.
EBS 12.2 issues seen in the wild
Recently, I was involved in an EBS upgrade project, and also in operational support of an EBS...
High system time on Windows running in a VM
Recently I've seen an issue with CPU usage on a server running Windows 2003 Server in a VMware....
