Tag: Oracle

How to Configure WebLogic as a Windows Service (in Just 4 Steps)

When you install WebLogic Server on the Windows platform, it might be a good idea to set it as a native Windows Service. The standard installation deploys the underlying scripts to create and uninstall the WebLogic server process as a…

Read More >

Investigating a Chain of Events Resulting in Occasional Query’s Degraded Performance in Oracle

A client asked us to verify why an INSERT AS SELECT statement, which was part of a scheduled ETL job executing on a single instance V11.2 database running as a data warehouse, suddenly started to take longer than usual. The…

Read More >

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 >

What You Need to Know About Oracle EBS 12.2 CPU – January 2023

I recently applied the January 2023 released E-Business Suite Release 12.2 CPU patches following the release document 2916871.1. Below are a few high-level notes that might be helpful for a quick reference for anyone taking up these patches. E-Business Suite…

Read More >

Using Oracle Linux Virtualization Manager (OLVM) to Restrict Cores

Organizations usually maintain Oracle licences for Oracle RDBMS Enterprise Edition on a per-core basis. It is possible to use Virtualization Managers to limit the resources assigned to virtual machine “guests”—and, subsequently, the databases within those guests. According to the Oracle Partitioning…

Read More >

After the migration: How to get the most out of your Google Cloud migration

All public clouds offer flexible computing, networking and storage. And you’re likely using at least one public cloud, if not two or more. But if you’re thinking about moving some of your mission-critical applications to the cloud—such as SAP or…

Read More >

ADOP edition cleanup

Oracle e-Business Suite administrators have access to pretty extensive documentation regarding Patching procedures. In Oracle EBS 12.2 Oracle introduced ADOP patching method along with Oracle Database EBR (edition-based redefinition) feature that allows minimizing downtimes for patching activities. As with everything…

Read More >

Oracle DBMS_CLOUD package with AWS S3

The package DBMS_CLOUD was first introduced in the Autonomous Database to provide a simple way to interact with an object store from the database. It is now available for on-premise databases starting with 19.9c and 21c. It works with OCI,…

Read More >

Interesting variations in outcome when cloning a CDB with a subset of PDBs in Oracle

Recently I was working on a client request where a CDB along with a subset of its PDBs had to be cloned to a new server for testing purposes. This post illustrates that in certain circumstances the outcome of this…

Read More >
Page 1 of 17112345...10...Last Page »