Tag: R12

Our mission at Pythian is to help you Love Your Data. Because security is a crucial part of managing your data, we are pleased to tell you about the identity management (IDM) solution Pythian has developed to make it easier…

As a managed service company, we see our customers and partners shifting their workloads to the cloud. There are various reasons for this decision, but the most important ones are cost and agility. Once on a cloud, the infrastructure team…

Cloning an Oracle E-Business Suite system is a complicated process, and depending on the environment topology, it can involve various steps to accomplish the task.     Partial automation of the E-Business Suite cloning procedure is often done with local…

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…

Something  exciting happened a few days ago. It started with a tweet and a blog post, and has evolved into an official CVE-2022-21500. I thought it would be good to publish some details beyond the official MOS note document.  …

In 2018, Oracle announced the release of Oracle Enterprise Command Centers (ECC) for E-Business Suite. This EBS add-on provides users with discovery-oriented dashboards that bring together diverse operational data from across Oracle E-Business Suite.     Oracle Endeca, its predecessor, needed…

For many of us, the recent log4j vulnerability (CVE-2021-44228) became a severe headache this past weekend. I thought we’d publish a summary of some of our findings gathered so far. We’ll  keep it updated with news and details published by…

I’m sure one of the most popular scripts for Apps DBAs on My Oracle Support is cmclean.sql from MOS Article ID 134007.1 “Concurrent Processing – CMCLEAN.SQL – Non Destructive Script to Clean Concurrent Manager Tables”. DBAs usually use the script…

This is the second article in a series about internals and performance of concurrent managers. In this post, we’ll take a look at three important settings that affect the performance of the concurrent managers: number of processes, “sleep seconds”, and “cache size”. This article might be a bit on the theoretical side, but it should provide a good understanding of how these settings actually affect the behavior and performance of concurrent managers.

This is the first article in a series about performance of concurrent processing. We’ll take a closer look at the internals of concurrent managers, the settings that affect their performance and the ways of diagnosing performance and configuration issues. Today we’ll start with an overview of the internal workflow of a concurrent manager process. Enjoy the reading!