Entries from Oracle E-Business Suite Technology tagged with 'performance'
Running E-Business Suite on Exadata V2
The Exadata Database Machine Version 2 was released at OpenWorld 2009 to great fanfare. Since its unveiling, I've been getting a steady stream of questions from E-Business Suite customers who are intrigued by Exadata V2's potential. All 11gR2 Database Applications are Compatible The E-Business Suite and other OLTP applications will run on the Exadata V2 system if they're certified with the 11gR2 Database on Linux. Oracle E-Business Suite Release 11i is certified on the 11gR2 database, so it can run on Exadata V2 today.
Recommended Database Parameters Updated for EBS 12
Close on the heels of our recent updates to the recommended EBS 11i Database parameters, our database and applications performance architects have published updates for EBS Release 12. The updated note is now available here: * Database Initialization Parameters for Oracle Applications Release 12 (MOS Document ID 396009.1)
Recommended Database Parameters Updated for EBS 11i
Experienced Apps DBAs know that there are often compelling reasons to tweak the E-Business Suite's database initialization parameters from the defaults. The master source-of-truth for whether certain parameter settings will help or hurt your EBS environment performance is published here: Database Initialization Parameters for Oracle Applications Release 11i (Note 216205.1) Our EBS database architects have just released an updated version of that Note. Recent updates over the last month include a number of important changes and additions to our recommendations
Which is Better: Forms Servlet or Socket Mode?
Many products within the Oracle E-Business Suite have screens that are built with Oracle Forms. Oracle Forms can be run in either servlet mode or socket mode. Apps 11i is based on Forms 6i and is configured to run in socket mode by default. Apps 12 is based on Forms 10g and is configured to run in servlet mode by default. What are these modes, and which is better?
What is Forms Servlet Mode?
The Forms Listener Servlet is a Java servlet that delivers the ability to run Oracle Forms applications over HTTP and HTTPS connections. It manages the creation of a Forms Server Runtime process for each client, as well as network communications between the client and its associated Forms Server Runtime process.
The desktop client sends HTTP requests and receives HTTP responses from the web server. The HTTP Listener on the web server acts as the network endpoint for the client, keeping other servers and ports from being exposed at the firewall.
Whitepaper Update: Database Partitioning for E-Business Suite
Maintaining your existing service level agreements (SLA) with your users becomes increasingly challenging as your E-Business Suite database grows. The knee-jerk reaction to a performance problem is often to throw more hardware at it. If you have a large E-Business Suite environment where the growth rate of your historical transactional data is starting to affect performance, there's another alternative to scaling up your hardware. It's possible that you could use database partitioning to squeeze some additional performance out of your existing environment without the added expense of new hardware.
Power Tools: Running AutoConfig in Parallel in EBS 12
[Editor's Note: This is the second of a series of four articles on new AutoConfig features. These articles are written by members of our AutoConfig Development team. This is your opportunity to interact directly with that team with your feedback on this tool.]
Our last article discussed ways of tuning your AutoConfig runs via profiling reports that identify bottlenecks during template instantiation. This article discusses another method of speeding up your AutoConfig runs. In an R12 E-Business Suite instance, AutoConfig can now be run simultaneously across multiple nodes. This new feature significantly lowers maintenance downtime for multi-node installations. One beta customer of this feature improved the time it takes them to run AutoConfig across their dozen mid tiers by 45%.
How Does AutoConfig's Parallel Mode Work?
Executing AutoConfig in 'parallel mode' engages a locking mechanism so that processes running on individual nodes are synchronized. This mechanism prevents any conflicting updates to the database or the file system. The following figure illustrates AutoConfig running in parallel across multiple nodes:
Power Tools: Optimizing AutoConfig Performance Through Profiling
[Editor's Note: This is the first of a series of four articles on new AutoConfig features. These articles are written by members of our AutoConfig Development team. This is your chance to get the inside track on these advanced features and provide your feedback directly to our developers.]
Ever wonder what's taking up the time during a given AutoConfig run in your E-Business Suite environment? Want to optimize the performance of your techstack configuration customizations? The AutoConfig Performance Profiler gathers data about an AutoConfig run and generates a consolidated AutoConfig profile report in HTML format. The report lists all product tops processed by AutoConfig along with the total instantiation and execution time of the templates within them. A beta customer of this feature helped us fix an indexing issue to allow AutoConfig to run in one third of the time.
The generated performance report allows you to drill down on each product top and view the following:
- Source and target location of individual templates
- Time consumed to instantiate or execute each template
- Execution report for each template
Here's a screenshot of the first few lines of the report:
Using Cisco ACE Series Hardware Load-Balancers with EBS 12
Oracle and Cisco Systems jointly certified the Cisco ACE Series Application Control Engine with Oracle E-Business Suite Release 12. Cisco ACE Series Application Control Engine is a new offering from Cisco Systems that has the potential to improve high availability, performance, security, optimized application deployment and lower the cost of ownership for Oracle E-Business Suite R12. The new ACE platform targets three main aspects, namely manageability, security and performance. The figure below shows the Virtualization and Role-based Admin features of the ACE module.
Smoking! Running Apps 11i on the HP Oracle Database Machine
Like every sysadmin I know, I yearn for bigger, beefier servers for my E-Business Suite environments. I've been dreaming about the new HP Oracle Database Machine since its unveiling at OpenWorld 2008.
In case you missed that announcement, this is a server with mainframe-class street cred: up to 14 GB/second in raw I/O bandwidth, which translates to up to 50 GB/second when handling compressed data. Storage scales up to petabytes when combined with the HP Oracle Exadata Storage Server. This machine is optimized for handling huge Oracle databases, so it's inevitable that EBS customers with large databases have shown interest in this hardware.
The Database Machine runs Oracle Database 11gR1 11.1.0.7 and Real Application Clusters on Oracle Enterprise Linux 5.1. We've just certified Oracle E-Business Suite Release 11i with the 11gR1 11.1.0.7 database release, so it's now possible to run Apps 11i on this hardware.
Tuning All Layers of the Oracle E-Business Suite (OpenWorld 2008 Recap)
I'm highlighting OpenWorld 2008 presentations that cover some of the most popular E-Business Suite technology stack topics. A catalog of all of the Applications Technology track sessions with links to the presentations is available here:
We have an Applications Performance Group whose raison-d'etre is to ensure that the E-Business Suite runs at peak performance in all circumstances. This team has helped tune the world's largest companies and their E-Business Suite environments to handle staggering amounts of transactional volume in enormous databases. This is the same group that publishes all of the official Oracle Apps benchmarks, white papers, and performance metrics.
Their OpenWorld sessions are a perennial favourite with hardcore Apps DBAs looking to squeeze out the last ounce of performance out of their existing hardware. Isam Alyousfi and Lester Gutierrez from our Applications Performance Group share their hard-won performance tuning tips in this in-depth session:
- Tuning All Layers of the Oracle E-Business Suite (PDF, 1.4 MB)
New Whitepaper: Database Partitioning for the E-Business Suite
Some readers complain that we don't have sufficient documentation to cover all possible scenarios and topics of interest. This is a valid observation. As your E-Business Suite deployments grow in complexity and scope, keeping ahead of your questions and new...
Two Essential Tools for Diagnosing E-Business Suite Network Issues
Network problems seem to be on the rise again, either due to the increase in service demands, integration of different technologies such as Voice Over IP (VoIP), and the inevitable increases in uptake of technologies at new locations. Not only do...
Optimizing R12 Performance via OC4J Load-Balancing
Oracle Application Server provides features that allow customers to load balance their middle tier deployments. OC4J Clustering in OracleAS 10g is one such deployment that is widely used in load balanced configurations. Starting with Oracle E-Business Suite Release 12.0.2 (Release...
Essential Debugging Tools For Apps 12
E-Business Suite Release 12 includes Oracle Application Server 10g components for Forms and Java, each hosted in their own ORACLE_HOMEs. A couple of colleagues in my team have published a pair of complementary Metalink Notes about debugging, diagnostic, and tracing...
Performance Tuning for the E-Business Suite
It's said that death and taxes are the only certainties. I beg to differ. There's at least one other for IT professionals: regardless of the amount of network bandwidth you've dedicated to E-Business Suite traffic, no matter how many application...
Best Practices for Upgrading to Release 12
If you've been considering the best way to upgrade your E-Business Suite Release 11i environment to Release 12, I strongly recommend that you check out Eugene Weinstein and Nigel Cooper's excellent OpenWorld 2007 presentation:Upgrading to Oracle E-Business Suite Release 12: ...
Analyzing Memory vs Performance of Apps 11i and 12 Clients
I've recently published a new Oracle whitepaper that compares combinations of browsers with JInitiator and the native Sun Java plug-in (JRE) to determine which is best for low-specification clients. It provides specific scenarios and examples showing where there is little...
Java Caching for Oracle Applications 11i: Part 2
In my previous article "Java Caching for Oracle Applications 11i: Part 1" I talked about the basics of Java Caching and how it works conceptually. My original intention with "Part 2" was to discuss how to diagnose issues with Java...
Understanding JDBC Connections From the eBusiness Middle Tier
In this article I will describe the basics of configuring and monitoring JDBC connections between the eBusiness Web Tier and the Database, then cover some common issues to help identify root causes for both Release 11i and Release 12 of...
WebCache 10g (10.1.2.2) Certified with Apps 11i and 12
Oracle Web Cache 10g (10.1.2.2) is now certified with E-Business Suite Release 11i and 12. E-Business Suite administrators may use the latest version of Oracle Web Cache 10.1.2.2 to provide caching, reverse-proxy, and failover and surge protection for their environments.Supported...
Search All Blogs
Google Search
Feed Subscription
If you use an RSS reader, you can subscribe to a feed of all future entries tagged 'performance'.
