How to Identify Tuning opportunity
Every issues we have tuning opportunities but before start to troubleshoot the issue we need to analysis the Issue. First need to collect basic level of information to user Second task is where to get the information to server Third task is find out the issue Most of the common performance problem causes due to Lack of Sufficient server hardware Ex: CPU,Memory,Storage,Network Poorly configured initialization parameters Poor application coding Collect the basic level of information to user Program Level: It’s happening in Prod/Non- Prod? Oracle seeded program/Custom program? How much time it used earlier? Any recent code changes done/not? How much data is getting processed? Application Level: I s this happening for all user or particular user? Is this happening all forms or particular forms? Application level performance issue Document click hear Where to get the information to server Hardware issues: Need to ch