Wednesday, July 18, 2007

Steps to Resolve Concurrent Processing Isuues(ORACLE e-Business Suite)

In this Post i am Explaining about Concurrent Processing issues & How to resolve them.

Introduction:

This Paper describes the day-to-day administrative like performance issues with concurrent processing etc. at Aurobindo Pharma Ltd., a leading pharmaceutical manufacturer, and the solutions to resolve those problem regarding performance of E-Business Suite. you may visit Aurobindo at http://www.aurobindo.com/.

The Goal of this Document is to assist existing Oracle Applications DBA’s and Administrators in identifying the hidden features of Oracle Applications 11i that will affect how they accomplish their day-to-day administrative tasks like managing concurrent processing.

Abstract:

This paper flourishes possible ways to speed up & utilize the processing capacity of Oracle Applications as per it’s maximum extent.

Concurrent Processing:

Before heading into the details of how to manage the concurrent processing, the following are definitions of key terms:

Concurrent Manager: Concurrent manager is a mechanism that runs concurrent programs. A manager operates during the time and days defined by a work shift. A manager can run any concurrent program, or be specialized to run any concurrent program, or be specialized to run only certain kinds of programs.

Concurrent Program: A program that runs concurrently (at the same time) as other programs. Concurrent programs run as background processes, while you continue to work at your terminal.

Note : Oracle’s guidelines for CPU suggested that Estimate the number of users who will use Oracle Applications simultaneously under normal circumstances.

For example We have 500+ end users. This number included multiple open sessions as well browses.

Users opened multiple sessions on their desktops, either to do work through two different applications at the same time, or because performance was so slow that they felt they could get more done with more screens open. As users became increasingly upset about performance, they opened more windows, causing the performance problem to increase because every log-in to Oracle costs about 2.5 MB of memory (2.5*500 users = 1.2GB Approximately).

Note-1: if we lower the number in the Priority field in the Navigate/Concurrent/Requests screen, then the concurrent request’s position in the queue will change and it will run sooner. Sooner, I always caution users, does not mean faster. Changing the priority does not cause the concurrent request to get more resources from the computer when it runs, so if the computer is already overloaded, you will still have performance problems.

Note-2: If we increasing the number of requests, that could run in the concurrent manager didn’t help either. If we plan to use this in Brake sessions with proper planning, it is the best option.

Note-3: if we decreased the size of the SGA. This freed up additional memory for the users to log on, but decreased the amount of memory available for the database, causing it’s own set of performance issues.

Note-4: When we calculated memory requirements, it’s better to assess the impact of Zooms on memory. Zoom- Zooms allow end users to suspend processing in one form, make a side trip to work or view details in another form, then return to the original form and resume processing. If a user zooms, it’s nothing but another login. It’ costs another 2.5 MB memory & it’s not release the memory until the user logoff.

To resolve the performance issues

Actions :

1. asses how many users will use the applications. even if they aren’t doing anything, the memory will be utilized.

2. Many users will log on at least twice.

3. Zooms didn’t release the memory until the user log-off.

4. Count the Concurrent managers themselves as users of memory & CPU.

5. The SGA also requires considerable memory.

Solutions:

1. From Unix, limit the users to logging in two times.

2. Implement a process @ the unix level to automatically kill sessions of users who were idle for more than an hour.

3. Set the correct balance of concurrent managers versus online user performance.

4. Using the scripts, asses the high frequency, high impact, average time & importance of the concurrent request.

6. Give the access on this output data to all users & give the choice to them for scheduling the job.

7. Encourage the users to schedule the requests (means long running & repeatable) to run in the evening.

8. Report the performance problems with forms & reports to the developers.

9. Check the parameters of running open-ended reports.

10. Monitor for locks on tables. Locks affect both online & batch operations.

11. Check for runaway requests mean long running requests, displays CPU clock time increasing & had a unix process id of 1 with no other processes referencing it. In this case, the process may not be cleaned automatically. Use the kill command to terminate the run-away requests.

12. Use the Apps Status Scan scripts & verify the performance issues.

13. Give instructions for users immediately close the database backend, ftp, front end sessions if they are not using.

14. During the Business hours give the preference for Online users & run atleast two processes per manager.

15. Sugests the users to close all sessions with Oracle Applications @ Brake times (lunch time).

16. Working with the above Step, A lot of memory will be released. Use it efficiently with increasing the target processes.

17. Workshifts:

Define workshifts like Business Hours, evening, weekends & End of the Month workshifts.

Business Hours : During the business hours, we had a workshift for 9AM – 6PM.

That minimized the no. of concurrent requests in favor of online users.

Evening Hours: At 6PM, change the workshift to Evening workshift & increase the no. of concurrent requests that could run. As performance improved, we gradually increased the no. of jobs that could run @ once.

Weekend: As per the company holidays, define this workshift & give the primary priority for concurrent requests.

If we properly manage these workshifts, there is no need Maintain any workshifts like Monthend shifts, quarterly shifts etc.

18. Run the purge concurrent requests & manager data programs nightly to delete old files.

19. Remove the older files if the /var/tmp is getting full.

20. Run the Oracle-seeded report User Profile Options periodically to catch users who have left debug or trace options turned on.

21. Monitor file system spaces frequently.

22. Avoid enabling an excessive number of standard or specialized managers.

23. Use specialization rules and work shifts to bind specific jobs to specific time windows.

24. Helps avoid scheduling resource intensive batch requests during peak activity.

25. For jobs, which spawn parallel workers such as Auto Invoice or Payroll, set the sleep time of the Conflict Resolution Manager (CRM) to null (i.e. 10 seconds). The default value is 60 seconds.

26. Transaction Managers:

1. Set the profile “Concurrent:Wait for Available TM” to 1 (second).

2. Set “TP:INV Transaction processing mode” to “On-line processing” for small inventory requests from the UI.

3. Set the sleep time on the transaction managers to a high number (e.g. 10 minutes).

4. Enable tracing if required.

27. Implementation of PCP(parallel concurrent processing) is the another solution to improve performance.
...........................................................................................

--

Srinivas Ramineni

Apps DBA


18 comments:

Anonymous said...

Here are a few of the most inexpensive cab organizations in Nevada that provide trustworthy 24 hour prefer to their customers [url=http://www.ubyvk.co.uk/]12 month loans[/url] 12 month loans These mortgage are avail online and there is and and also alongside the car itself http://www.ibydh.co.uk/

Anonymous said...

For our Topic, we will bonuses; Release french fries and Release recreate offers. [url=http://www.oiupaydayloans.co.uk/]quick payday loans[/url] payday loans mummy So, at any clock time during your represent, you can attend deposits some amount of money in his History with the casino. http://www.bvnvpaydayloans.co.uk/

Unknown said...

payday loans
doorstep loans uk
These Payday loans & Doorstep Loans are the most convenient and quick, The application, approval and payment process is completely online.

Unknown said...

12 month loans UK

12 month loans
12 month payday loans
http://12monthloansuk3.co.uk/

12 month loan said...

These can only help . few cases in kojimakredit payments doorstep loans based on the discount on your swimming pool has number of other cases , such as broken car, or a family history of this type of loan 12 month loans no credit check can be very useful.

Unknown said...

Get quick loans and 12 month loans,also people with bad credit can apply, No fees and no credit check needed.Approval in 24hre and get funds in your account.
Other link : 12 month loans

quick loans said...

This loan this is a viable option for people instant loans with disabilities who have nothing to place as collateral to borrow money against the loan amount.

payday loans online said...

So, even if you are suffering from bad or adverse credit tags, you do not need to worry about. The no credit check loans lender would simply ignore your bad credit tags like arrears, defaults, insolvency, bankruptcy, missed payments, CCJs and IVAs, etc.

Unknown said...

Before taking a payday loan for this study closely the scheduled trips. If there are several of them in a year, skip the one with the least educational value. Field trips are important and offer lessons for education and valuable life, but maybe not a good reason to take a payday loan online.

http://www.ukpaydayloansprovider.co.uk/
http://www.e6monthpaydayloans.co.uk/

Unknown said...

Cash loans to your door are designed to provide funds to borrowers at their door quick loans when they havenâ € ™ ta lot of times because of the tight labor expected, but it is necessary to access the money to overcome emergencies.

http://www.equickpaydayloansuk.co.uk/

Unknown said...

A person who borrows money for their household to function eventually further debt payday loans because of high interest. The cost of borrowing is something to seriously consider before borrowing. Calculate how long it will take to payday loans online pay and how to integrate this additional cost in the budget. If this solution is more cost effective in the long term, use the method of quick payday loan safe practice.

Unknown said...

Apply loans in following SItes

Bad Credit Text Loans
payday loans no credit check
12 month loans
No Credit Check Loans
Text Loans
Bad credit loans provider
Unsecured loans bad credit
Text Loans
Instant loans
Bad credit loans direct lender
No credit check loans

Unknown said...

In addition, it is ideal for business travelers, the one device that is not on and provides a perfect mobile office on the go without compromise as his own request. galaxy s5 deals The Asian manufacturer also includes a fresh accessory in the form of the S Pen, which comes with each unit. Incorporated, to work seamlessly with the built-in software, tech buffs can easily draw sketches with laser point accuracy. Users can easily write down notes, emphasize something on a website, and much more.
http://www.esamsunggalaxys4deals.co.uk/
http://www.yessamsunggalaxys4deals.co.uk/
http://www.samsunggalaxys4deals-uk.co.uk/
http://www.samsunggalaxys5contractmobiledeals.co.uk/



Anonymous said...

Your blog is really Good & Enjoyable. Few days back I applied for a doorstep loans and the lenders sanctioned loans shortly without any additional demands. They have an special offer of '12 month Loans'. If you need urgent cash you can apply here @ www.quickdoorstep12monthloansnoguarantor.co.uk - Its really Great! Here is a simple way that you might not hesitate, because, as there are a number of advantages and is very useful when you need financial assistance to decide.

Unknown said...

These people need to submit some basic details related to their stable job that no more than that. Thus, people are able to get just the availability of funds to only their door. So do all the formalities and get the last minute funds over the period of time. 12 month loans The lender does not include unnecessary formalities for borrowers, who are blessed with the whole criteria required by the loan provider.
http://www.easypaydayfinance.co.uk/12-month-payday-loans.html
http://www.easypaydayfinance.co.uk/long-term-payday-loans.html


Unknown said...

short term loans
quick loans
With this cash advance, people can solve sudden monetary requirements on time. So if you're stuck with unexpected expenses in the middle of the month and facing shortage of cash, then this loan segment can help you a lot. In other words, these loans have emerged as popular tax package for employees who are in great need of emergency funds. With the help of the service, consumers can receive financial aid from 80 to 1500.
http://www.financhelp.co.uk/
http://www.financhelp.co.uk/Quick-loans-online.html
http://www.financhelp.co.uk/3-month-payday-loans.html
http://www.financhelp.co.uk/same-day-payday-loans-for-people-on-benefits.html

oakleyses said...

ray ban uk, coach purses, polo lacoste, sac vanessa bruno, nike tn, hogan outlet, michael kors, michael kors outlet online, converse pas cher, nike air max uk, kate spade, michael kors outlet, hollister pas cher, uggs outlet, coach outlet, north face, michael kors outlet, north face uk, nike air max uk, ray ban pas cher, uggs outlet, nike air force, ralph lauren uk, mulberry uk, lululemon canada, nike free uk, true religion jeans, guess pas cher, replica handbags, timberland pas cher, nike blazer pas cher, coach outlet store online, michael kors outlet online, burberry handbags, abercrombie and fitch uk, michael kors, nike air max, michael kors outlet, vans pas cher, oakley pas cher, true religion outlet, hollister uk, nike roshe run uk, sac hermes, true religion outlet, new balance, michael kors outlet online, burberry outlet, true religion outlet

oakleyses said...

canada goose, moncler outlet, canada goose outlet, toms shoes, montre pas cher, louis vuitton, moncler, canada goose, swarovski, juicy couture outlet, louis vuitton, replica watches, links of london, moncler, canada goose uk, moncler uk, hollister, wedding dresses, thomas sabo, karen millen uk, canada goose outlet, barbour uk, louis vuitton, ugg uk, ugg,ugg australia,ugg italia, moncler outlet, doudoune moncler, ugg,uggs,uggs canada, canada goose, supra shoes, coach outlet, canada goose outlet, ugg pas cher, ugg, pandora uk, louis vuitton, canada goose jackets, juicy couture outlet, moncler, marc jacobs, louis vuitton, pandora jewelry, lancel, swarovski crystal, pandora jewelry, pandora charms, barbour, moncler