2 Replies Latest reply: May 17, 2012 1:21 PM by LKBrwn_DBA RSS

    pls help

    930576
      we have asp.net application connect with oracle 11g

      how can know the slow in system not from database?
        • 1. Re: pls help
          713555
          Have you read any documentation/concepts on Oracle database?

          If not you could read a hundred pages of replies and not get near your answer as you wont be able to understand them.

          high level ask these questions before you go near the database.

          Where is the application slow?
          who is it slow for?
          is it slow at particular times?
          Has there been any changes in the application?
          Was it ever fast? whats changed since it was fast to when it got slow.
          Have you a test environment? ask all the above questions of that as well.
          • 2. Re: pls help
            LKBrwn_DBA
            ahmed.elghoury wrote:
            we have asp.net application connect with oracle 11g

            how can know the slow in system not from database?
            Ask your DBA to generate an ADDM or ASH report for the period in which the asp.net application was executing slow.
            :p