Checking Free Space of UNDO Tablespaces
Introduction This blog is a high-level overview of the fundamental Oracle feature UNDO tablespace...
Introduction This blog is a high-level overview of the fundamental Oracle feature UNDO tablespace...
One of our clients patched its EBS database 19.13 to DBRU 19.17 and faced an issue with one of the...
A new client was experiencing regular issues with its OA Core servers on its EBS 12.2 environment....
We recently completed a few e eBS R12.2 database upgrade installations and noticed an issue with a...
No, it’s not the PlayStation Network! Linux Process Snapper — pSnapper, or psn — is an open source...
A recent Twitter thread had an interesting test case of the optimizer choosing sub-optimal skip...
Short summary: Queries to ALL_SYNONYMS cause FTS of SYS.OBJ$ which can't be avoided.
Recently, I was involved in an EBS upgrade project, and also in operational support of an EBS...
A quick and easy way to know what is it inside Java process that is using your CPU. Using just...
Our monitoring software found a long running job on one of our client's databases. The job was an...