Recently I spent some time trying to migrate root partition to another FS type in an OVM environment. The target was to migrate root partition from btrfs to ext4. Here is a short outline of how it was done. 1….Read More >
A recent Twitter thread had an interesting test case of the optimizer choosing sub-optimal skip scan over range scan. I’ve checked what’s going on, and it happens to be a known bug. Here’s a slightly simplified test case: [sourcecode lang=”sql”…Read More >
Short summary: Queries to ALL_SYNONYMS cause FTS of SYS.OBJ$ which can’t be avoided.Read More >
Recently, I was involved in an EBS upgrade project, and also in operational support of an EBS production environment. Based on this project, here is an unsorted list of issues I’ve seen in or around the EBS core. EBS architecture…Read More >
Recently I’ve seen an issue with CPU usage on a server running Windows 2003 Server in a VMware. This is a small Virtual Machine with just 2 cores allocated (which are possibly mapped to “threads” on a host level but…Read More >
A quick and easy way to know what is it inside Java process that is using your CPU. Using just Linux command line tools and JDK supplied command line utilities.Read More >
Our monitoring software found a long running job on one of our client’s databases. The job was an Oracle’s auto task running statistics gathering for more than 3 hours. I was curious to know why it took so long and…Read More >
The question of whether a database has enough redo logs available is quite common. The documentation suggests to use FAST_START_MTTR_TARGET and V$INSTANCE_RECOVERY.OPTIMAL_LOGFILE_SIZE to identify “the optimal” redo log size based on the target recovery time. I’ve never used it and…Read More >
© Copyright 2019 Pythian Group Inc. ® ALL RIGHTS RESERVED.
PYTHIAN®, LOVE YOUR DATA®, and ADMINISCOPE® are trademarks and registered trademarks owned by Pythian in North America and certain other countries, and are valuable assets of our company. Other brands, product and company names on this website may be trademarks or registered trademarks of Pythian or of third parties. Use of trademarks without permission is strictly prohibited.