Applications Tuning Doc

Applications Tuning Document

• 1. Detailed description of the performance issue:

  2. TAR Number:

  3. Application Product Name:

  4. Application Product ID number:

  5. Environments on which problem is occurring (i.e., Test, Development, Vision, Production, All):

  6. If poor performance on multiple environments, is it consistent regardless of system load or is it occurring more often in some situations?

  7. How many users are affected?

  8. If more than one, are users at more than one site equally affected?

  9. Can it be reproduced?

  10. If yes, explain conditions and steps taken to reproduce:

  11. Available workaround:

  12. When did this complete correctly without performance problems?

  13. Any software (e.g., RDBMS, OS, Apps, Third Party) that has been installed or upgraded since problem started:

  14. Any software (e.g., RDBMS, OS, Apps, Third Party) that has been installed or upgraded since last worked correctly:

  15. Patches (e.g., OS, RDBMS, Apps, other software patches on same system) applied recently:

  16. Patches required to fix the issue:

  17. Currently running certified configuration?

  18. Most recent patches or minipacks applied?

  19. Frequency of statistics gathering:

  20. Method of statistics gathering:

  21. Tool used to gather statistics:

  22. Estimate percentage used:

  23. Last time statistics gathered:

  24. Are all initialization parameters set at Applications required levels? (To check, run bde_chk_cbo.sql, which can be obtained through Metalink Note 174605.1)

  25. Initialization parameter changed due to resulting report:

  26. How long does it take for the offending process to complete?

  27. How long did it used to take (performance expected)?

  28. Any customizations that may be affecting this process:Module short name:

  29. Module descriptive name:

  30. Module version:

  31. Latest module version available:

  32. Patch set level for module:

  33. Latest patch set for module:

  34. Operating unit used (only applicable if you are multi-org):

  35. Parameter names and passed values for Concurrent Programs:

  36. Form and Field navigation involved:

  37. Transaction involved:

  38. Applications trace file created?

  39. Has TKPROF been done on resulting trace?

  40. SQL statement performing poorly (per TKPROF)?

  41. Event 100046 trace done?

  42. Wait events for poorly performing transaction?

  43. Metalink Search done for transaction?

  44. Resulting note numbers (attach printouts of relevant notes and results of trying suggestions):

  45. Any custom indexes on tables involved in SQL found in trace?

  46. If iTAR created, list files uploaded?

  47. Suggested fix steps with results:

  48. Back end tuning specifics:

      1. 1. Architecture information:

         2. Hardware profile of database server:

         3. Hardware profile of middle tier:

         4. Server workload profile:

         5. Do other transactions on same server report performance problems?

         6. Current system load:

         7. Projected system load:

         8. Concurrent Processing policies:

         9. Known resource contention (e.g., SAN, Memory, IO, CPU)? Event 10046 trace may alert you to existing contention issues.

         10. Apps modules installed and minipack level of each and latest available for each?

         11. OSs involved, their version numbers, and patch levels:

         12. Existing hardware recommendations:

  49. Tech Stack Tuning Specifics:

• • • 1. Form version:

      2. Report version:

      3. JInitiator version:

      4. Browser used and version: