Tag: performance

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 >

Managing the Performance of Grafana/Prometheus Dashboards using Nginx & Lua

Is your Prometheus performance causing your Grafana experience to suffer? Could you explain which of your tens of Grafana dashboards or users are causing performance problems in Prometheus? Let me show you how we unlocked insight into the performance of…

Read More >

Why your Cassandra cluster scales poorly

Apache Cassandra promises linear scalability and workload distribution, among many other features—and rightly so. However, as with many good things in life, these benefits come with a set of upfront conditions. When the use case aligns with the architectural limitations,…

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 >

How to Overcome the Top 10 SQL Server Performance Challenges

Working with consulting clients is rewarding, interesting, and challenging. In discussion with some of my colleagues, I’ve noticed the same performance challenges come up over and over again across clients with completely different hardware, industry verticals, levels of staff seniority,…

Read More >

Seven Reasons You Need a SQL Database Health Check

Database unavailability or outright failure is no joke. Not only do such incidents often cause massive internal stress (along with the inevitable blame game between IT staff), but they can also negatively impact business outcomes and lead to dissatisfied or…

Read More >

Query Statspack’s “SQL ordered by” Sections Over a Time Period

In this post, I’ll present the statspack_top_sqls.sql script, which returns SQL performance statistics by mining the Statspack repository. In a previous blog post, I presented the statspack_load_trends.sql and the AWR_load_trends.sql scripts, which provide a high-level overview of workload dynamics on…

Read More >

Mining Statspack and AWR Repositories for Historical Trends

There are various ways that we can approach the analysis of a past database performance problem. The initial steps usually differ based on their scope. Is it limited to a certain SQL/process/task, or is it perceived as a database-wide slowdown?…

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