6 Replies Latest reply: Apr 28, 2013 9:09 AM by Paulie RSS

    performance tuning

    1005886
      Hi friends Myself Anand

      Please suggest me how to analyze AWR,Addm reports
      My sql query is running slowly its take long time to execute how to tune the issue
      and tell me 2 major performance issues in the database
        • 1. Re: performance tuning
          KR10822864
          1002883 wrote:
          Hi friends Myself Anand

          Please suggest me how to analyze AWR,Addm reports
          My sql query is running slowly its take long time to execute how to tune the issue
          and tell me 2 major performance issues in the database
          refer below MOS notes excellent and awesome guide.
          Oracle Performance Diagnostic Guide (OPDG) [ID 390374.1]
          • 2. Re: performance tuning
            sb92075
            HOW To Make TUNING request
            SQL and PL/SQL FAQ
            and tell me 2 major performance issues in the database
            actually there are three; CPU, RAM & I/O
            • 3. Re: performance tuning
              saratpvv
              Here you go...

              http://savvinov.com/2012/04/06/awr-reports-interpreting-cpu-usage/

              http://practical-tech.blogspot.in/2012/05/how-to-read-awr-report.html
              • 4. Re: performance tuning
                1005933
                hi Anand,
                 Please suggest me how to analyze AWR,Addm reports 
                - Why do you need to do that? I would suggest you have a good fundamental understanding of wait event before expecting yourself to understand awr reports. You can start with v$session ,ash,ash history and then transition for awr.
                Below book is good understanding wait events.
                Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning

                My sql query is running slowly its take long time to execute how to tune the issue
                I don't think awr "REPORT" will help you much here. Views like v$sql,v$sqlstat,v$sql_plan_monitor, ASH are good help you with where the time is spent etc.
                Also sql trace is helpful.
                and tell me 2 major performance issues in the database
                Didnt understand what you are looking for. Did anyone complain? What exactly were they saying? Can u give details?
                • 5. Re: performance tuning
                  Justin_Mungal
                  perfguy wrote:
                  hi Anand,
                   Please suggest me how to analyze AWR,Addm reports 
                  - Why do you need to do that? I would suggest you have a good fundamental understanding of wait event before expecting yourself to understand awr reports. You can start with v$session ,ash,ash history and then transition for awr.
                  Below book is good understanding wait events.
                  Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning
                  I would suggest reading the performance tuning guide before any other books. That's just me though.
                  http://docs.oracle.com/cd/E11882_01/server.112/e16638/toc.htm
                  • 6. Re: performance tuning
                    Paulie
                    >


                    Hi Anand, and welcome to the groups.

                    Please suggest me how to analyze AWR,Addm reports
                    My sql query is running slowly its take long time to execute how to tune the issue
                    and tell me 2 major performance issues in the database
                    Your question is impossibly vague and requires that you read the basic
                    docco - you have already been pointed to that. Then you should get
                    a/some book(s) and work through them - Tom Kyte and Jonathan Lewis
                    are worth looking at, and Christopher Lawson.

                    These groups are more about providing answers to specific questions,
                    we are a volunteer forum and do not provide courses on large areas
                    of Oracle's features.

                    Please read my mini-meta-FAQ below my signature, do some (serious)
                    reading and get back to us with either specific problems or particular
                    issues that you are having trouble understanding. Oracle is not
                    a system that you will learn in a couple of days.


                    Paul...


                    These forums are a great resource and you will get out
                    of them what you put in.



                    Forum FAQs.

                    oracletechnet (Etiquette)
                    https://wikis.oracle.com/display/Forums/Forums+FAQ
                    SQL and PL/SQL (also applicable to Oracle.general)
                    https://forums.oracle.com/forums/ann.jspa?annID=1535

                    note in particular:

                    How do I ask a question on the forums?
                    SQL and PL/SQL FAQ

                    Eric Raymond's "How to ask questions the smart way"
                    http://www.catb.org/esr/faqs/smart-questions.html

                    The Oracle docco is available here - tahiti.oracle.com

                    Mr. Google is your friend, use him before* posting.
                    And then search these forums, again before* posting.

                    Excellent sites for sample code are here
                    http://www.orafaq.com
                    http://www.oracle-base.com
                    http://www.oracle-developer.net
                    http://www.psoug.org



                    Then* post here.

                    Remember to describe your problem clearly and
                    succintly in the post's title.

                    In the post.

                    Don't forget to mention your 4 digit Oracle version
                    and your OS.

                    ==================

                    Please provide sample data in the form of
                    working* (test before posting) statements.

                    CREATE TABLE Blah(...

                    INSERT INTO Blah VALUES(...

                    Show desired results.
                    Explain why* you are doing what you are doing.


                    =================