Database Blog

How Oracle 19c Protects SQL Performance Using SQL Plan Management (SPM)

How Oracle 19c Protects SQL Performance Using SQL Plan Management (SPM)  What is SQL Plan Management (SPM)?  SQL Plan Management ensures that only known and verified execution plans are used for a…

Read More

Copying Table Data from Source to Destination in SQL Server

Purpose and Scope  This document describes the procedure to copy table data from a source server to a destination server using the SQL Server Import and Export Wizard. This method is commonly used for…

Read More

Basic SQL Performance Tuning tips

The purpose of this article is to give newbies some basic advice about SQL performance tuning that helps to improve their query tuning skills in SQL Server.    Introduction We…

Read More

How to Add a Database to an Existing Always On Availability Group

   Introduction : Always On Availability Groups is a high-availability and disaster-recovery feature in SQL Server that ensures database continuity with minimal downtime. In this blog, I explain the step-by-step process to…

Read More

Oracle EBS Security Under Control: Automated Audits with FND Tables

1. Security Model Overview Oracle EBS security is built on a multi-layer authorization model: FND_USER → user identity FND_RESPONSIBILITY → functional access FND_USER_RESP_GROUPS → assignment mapping Unlike database roles, EBS…

Read More

Why OACORE Slows Down: A JVM Health Monitoring Guide for EBS 12.2

1. Background & Architecture Context In Oracle E-Business Suite 12.2, OACORE is the primary Java container responsible for handling: OA Framework pages Forms servlet communication XML Publisher services REST and…

Read More

High_Severity_)Vulnerability

Oracle E-Business Suite Hit by New High-Severity Vulnerability (CVE-2025-61884) Overview Oracle has disclosed a new high-severity vulnerability, CVE-2025-61884, affecting Oracle E-Business Suite (EBS) versions 12.2.3 through 12.2.14, as documented in…

Read More

Remove_Used_Disk_from_an_ASM_Disk_Group_in_Oracle_19c_RAC

How to Safely Remove a Used Disk from an ASM Disk Group in Oracle 19c RAC Removing or deleting a used disk from an ASM disk group in Oracle 19c…

Read More

Configuring OSWatcher on Linux Systems

Introduction: Performance issues on Linux servers rarely announce themselves politely. A database slows down for a few minutes, an application freezes under load, or disk latency spikes during peak hours—only…

Read More

Configuring a Reverse Proxy on a Linux VM Using NGINX

Introduction  In many Linux-based environments, applications are deployed on separate virtual machines or run on different ports of the same VM. While this approach offers flexibility, it also introduces operational…

Read More