| Home | Tips | Papers | Disclaimer | Privacy |
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 want to know why "its" slow they get the description of the response time….
You could see the user's eyes fog over.
When trying to work with the business 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. eg. the raising of a PO thru goods dispatch.
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.
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-Bussiness Suite product mentioned in this paper is no longer available.
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 reports is available in the Free Reports page under the section
performance
WARNING - BEFORE YOU DO ANYTHING
Please refer to our Disclaimer.
Oracle®, Oracle Applications® & Oracle E-Business Suite® are registered trademarks of Oracle Corporation
TOAD® is a registered trademark of Quest Software
© 2009 G Piper
All Rights Reserved.