Oracle E-Business Suite

Running JRE7 alongside JRE6 for Oracle Forms

DBAs working in a managed services environment often run into situations where some customers are still running JRE6 while others have upgraded to latest JRE7. When JRE7 is installed on a Windows desktop, it becomes the default JRE and gets invoked when users access Oracle forms. This creates all kinds of issues for users who…

Discoverer 11.1.1.7 Installation and Integration to R12.1.3 Instance

This blog gives instructions on how to install Discoverer 11.1.1.7 and get it integrated to your R12.1.3 instance. For easy installation, I have provided all of the important screen shots in a slidehare Word document. These will guide you through all the steps. You can find it here ==> Discoverer 11.1.1.7 Installation and Integration to…

Improve Gather Stats in Oracle E-Business Suite

One important aspect of a healthy Oracle database is database statistics. It’s the main data on which CBO feeds to generate good execution plans for SQLs. Implementing a periodic and consistent gather statistics procedure in Oracle E-Business Suite is every Applications DBA’s duty. But often I see that they are not set up properly to…

Be Warned: cmclean.sql Is Dangerous!

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 to clean up stale data from concurrent processing tables (FND_CONCURRENT_%) after incidents like a crash…

Performance Settings of Concurrent Managers

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.

How to Fix the Oracle EBS 12.1.3 JDBC Connection Lock Issue

As with any product, there is always an increased risk of bugs when a new feature is introduced. Oracle E-Business Suite is no different. In release Release 12, Oracle introduced a usability feature called Configurable Homepage. This is a new homepage layout that is drastically different from 11i. This feature brings in a new gamut…

Day 1 at Oracle Open World Did Not Disappoint

The day was action packed with sessions and I presented my Oracle rman:Don’t Forget the Basics to an enthusiastic crowd in Moscone west. The room was close to full with some hanging out at the back. It has been a while since I have presented in a room so close to being full. There was a handful of questions and comments during the session and a group of attendees approached me to follow-up afterwards.

Around the World in a Day: Oracle Apps Upgrades the Pythian Way

Pythian’s Oracle Apps DBA team recently upgraded a client’s E-Business Suite system to version 12.1.3, bringing them into compliance with Oracle’s baseline support requirements for Release 12.1 nearly one year ahead of deadline. We’d like to tell you a bit about this project — not to toot our own horn (though that’s nice too, we are kinda proud), but because it provides an ideal illustration of the power of the Pythian service delivery model, particularly as it applies to large enterprise-class projects.

Page 1 of 512345