Tag: Oracle E-Business Suite

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…

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…

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…

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.

Are you ready to learn how to deploy the Oracle VM templates in Oracle VirtualBox, so you can run them on your own workstation without the need to run Oracle VM Server? I hope you are, because let me tell you, I’ve done a lot of typing. Whew.

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.

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.

Oracle hosted a webcast of Sysadmin-oriented Preview of EBS 12.2. It was an enlighting webcast, which gave a very good idea about things coming up in Release 12.2. Today I want to discuss about a prominent feature of the upcoming Oracle E-Business suite Release 12.2, Online patching feature. The screengrab in thiis post of a slide from presentation gives a nice overview of the feature.

Oracle Fusion Applications 11G is now available! You can get the installation from the Oracle E-Delivery site in no time. This is the moment many of us have been waiting for, if not for many years then for many months for sure. Keeping in mind the amount of effort Oracle have invested in the product and the fact that the product is going to be a flagship ERP system on the market for at least next 10 years the most important thing is to get an access to the documentation. For me to understand the concepts and fundamental principals of the product is much more important than getting it installed ASAP. Let’s get into it.