PIPER-Rx - E2E and SLA's

Oracle E-Business Suite Resource Centre

Paper - A business approach to Oracle E-Business Suite response time, E-to-E and SLAs

Paper - A business approach to Oracle E-Business Suite response time, E-to-E and SLAs

I wrote this paper for the Irish Oracle User Group held in Dublin 2005 whilst working for Quest Software. I also presented this paper in both Sydney Australia (AUSOUG) and Auckland New Zealand (NZOUG) in 2005.

At the time I wrote the paper I was quite disillusioned that the mind set in the industry around End to End was that a transaction was a technical transaction that could be measured by the technical staff i.e. a piece of SQL.

So when a user wants to know why "its" slow they get the description of the response time something like this….

"The transaction ( SQL statement) spent 200 milliseconds at router XYZ and then 1,400 milliseconds processing at the database"
You could see the user's eyes fog over.
This typically drives users crazy. When trying to work with the business remember a "real" transaction is not a discrete piece of SQL and does not stop at the PC. Remember that users of Oracle E-Business Suite are business people and a transaction that users understand is a usually business process. e.g. the raising of a PO thru to goods receipt.

But this form of transaction (business) is made up of a large number number of activities, forms and SQL code. As these could not be linked by the technicians this form of transaction was largely ignored.

There are two real measures of response time:

Measure one:

Oracle provide a concurrent program (FNDOAMCOL) to collect all the information required for their Oracle Application Manager (OAM) product.

This is one of the very useful programs Oracle provide.

1: You have to run it ( every 10 minutes by default) 2: It does the same thing every time it runs (consistent activity) and exercises a good portion of the application

So the run time of this program will represent the overall performance of the database.

If the database is working hard the runtime will be longer…

So plotting the response time of this program is a very good indicator of the overall performance of the application, and the charts look good even to the most system illiterate staff.

Measure two:

Workflow: You can track the response time of a business process with Workflow.

Eg.. Creation and approval of a purchase order..

Workflow records the start time and the end time for each PO workflow.

Now you have the response time of a business transaction.

In this case the response time of a form < 1 minute becomes irrelevant in the overall transaction that could take a week.


All too often the big three (3), End-to-End, Response Time and Service Level Agreements (SLA’s) whilst often a business initiative, are usually defined by the technical teams, who in turn produce technical results that have little relevant meaning to the business owners / users.

The ability to collect technical transactional details (eg. round trips and execution of an SQL statement) are often mistakenly referred to as end-2-end, which are then usually defined as a response time which eventually make their way into an SLA.

The fact that an SQL statement took 300 milliseconds at router ABC and 3.2 seconds at the database might be useful in diagnosing a performance issue it is basically irrelevant to the business owner / user.

This presentation will present a business focus covering the following topics:

Hope you find it useful.

View / Download powerpoint from Irish Oracle User group dublin 2005 (.pps format)

Note: The Quest Software Spotlight on E-Business Suite product mentioned in this paper was deleted from the Quest product suite in July 2008.

Back in 2004, I wrote a piece of SQL to collect the runtimes of the FNDOAMCOL progam for the past seven (7) days into half hour segments including the average and standard deviations. The output was then pasted into an Excel spreadsheet that produced a chart. Worth a look but you will need to be able to run SQL.

View / Download Response time SQL(.sql format)
View / Download Response time spreadsheet (.xls format)
A preformatted report is available in the Free Reports page under the section performance.

Last update: May 2009