Author: 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 seeded programs. The program took longer to run, causing delays in concurrent processing due to incompatibility rules with other programs.

Read More >

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. The issue caused high CPU usage on the OA Core nodes up to 100% and sometimes caused OutOfMemoryError to appear in the logs….

Read More >

Slow Query in eBS AutoConfig with DB 19c

slow query

We recently completed a few e eBS R12.2 database upgrade installations and noticed an issue with a particular SQL running as part of the AutoConfig.       The query sql_id is 5da8tjzfafw6j and it looks like this (formatted): select…

Read More >

Two Cases of Troubleshooting with psn

No, it’s not the PlayStation Network! Linux Process Snapper — pSnapper, or psn — is an open source tool written by Tanel Poder. Tanel provides a number of great examples on how to use psn and even a few videos…

Read More >

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 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 >

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 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: We have…

Read More >

Inefficient queries to ALL_SYNONYMS

Short summary: Queries to ALL_SYNONYMS cause FTS of SYS.OBJ$ which can’t be avoided.

Read More >

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 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 >

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. 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 Simple Way to Monitor Java in Linux

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 >
Page 1 of 212