Database Blog

Frequently Encountered ECC Challenges in Oracle EBS

Oracle Enterprise Command Center (ECC) significantly improves the Oracle E-Business Suite user experience by providing role-based dashboards, data visualization, and powerful search capabilities. However, like any integrated enterprise solution, ECC…

Read More

Oracle Enterprise Command Center (ECC) V13 Installation and Integration with Oracle E-Business Suite 12.2.5

Overview Oracle Enterprise Command Center (ECC) provides a modern, search-driven user experience that enables business users to analyze transactional data through interactive dashboards. Integrating ECC with Oracle E-Business Suite (EBS)…

Read More

Installing DBMS_CLOUD on 19c

Description DBMS_CLOUD is the Oracle package that lets the database connect to cloud object storage (OCI, Amazon S3, Azure Blob Storage) to create credentials, query external tables over cloud files,…

Read More

Real-Time MongoDB Performance Monitoring Using jq

Learn how to build lightweight, production-ready Bash and PowerShell scripts using jq to stream database logs and monitor server metrics in real-time. In our previous blog, we discussed using jq…

Read More

Installation and Configuration of Apex 26.1 in Oracle 26AI Database

Introduction: Oracle APEX is Oracle’s low-code development platform that enables developers to build secure, scalable, and enterprise-grade web applications with minimal coding. A successful APEX deployment requires proper installation and…

Read More

Red Hat Satellite Content Views, Lifecycle Environments and Activation Keys – A Practical Enterprise Design

Introduction/ Issue  Managing software packages and updates across hundreds or thousands of Red Hat Enterprise Linux (RHEL) servers can quickly become difficult without a structured approach. In many organizations, systems…

Read More

Azure VM Restore from One Region to Another Using OS Disk Snapshot

Introduction/ Issue  Disaster recovery and workload migration are common operational requirements in cloud environments. There are situations where an Azure Virtual Machine (VM) needs to be recreated in another Azure…

Read More

Upgrade Oracle Container Database from 19c to 26AI using AUTOUPGRADE Utility.

Introduction: Keeping Oracle databases on supported releases is essential for security, performance, and access to new features. Oracle AI Database 26ai introduces several enhancements over Oracle Database 19c, making it…

Read More

Optimizing Oracle Data Guard: Reducing Archive Logs & Apply Lag

Issue  On an Active Data Guard configuration, we noticed periods where archive log generation on the primary spiked well above normal, and the standby’s apply lag grew along with it.…

Read More

Boosting Analytic Query Performance with Oracle Database In-Memory

Introduction   A set of reporting and analytic queries against a large, frequently scanned table were taking longer than expected, with a large share of the response time going into repeated buffer cache…

Read More