Reg AWR report analysis
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Reg AWR report analysis

  1. #1
    Join Date
    Aug 2008
    Posts
    1

    Reg AWR report analysis

    Hi everyone,

    My database is sitting on Win 2003 HP server. Database size is about 2TB. and we are using onlt FTS. no indexes.
    have 2000 datafiles scaterd in diferent SCSI drives.
    Could any body suggest me which keypoints i need to see in AWR report to analyze it.

    Please help me. I have the .html AWR reports with me....

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    2TB database with no indexes?

    You don't need any AWR report, you are far away from having to look into it.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,469

    Thumbs down FTS. no indexes

    Quote Originally Posted by haihello4you
    ...and we are using only FTS. no indexes.
    You are wasting your money paying for Oracle if you are not using it.

    Maybe it's cheaper to just create flat files.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  4. #4
    Join Date
    Nov 2001
    Posts
    335
    What is the logic behind not using indexes? Why are you only using FTS?
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  5. #5
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    I guess you got enough suggetions now.

    Look for Top 5 Timed Events .

    There should be scattered read in the top wait events.

    Then look into the "SQL ordered by Reads".
    Get the sql and now you better know what to do with them.
    http://www.perf-engg.com
    A performance engineering forum

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by malay_biswal
    There should be scattered read in the top wait events.
    Dang! you are good man, how did you figure it out top wait event would be scattered read in a indexes-less database? The poor guy is already bleeding on the floor, no reason to kick him.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #7
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    @PAVB
    I know what i'm. I do not need any goddamn comments on that front.

    Let's come to the point. When the sqls get tuned the scattered read will be less now and that's what a good indicator for him to know from AWR report how much tuning required.
    http://www.perf-engg.com
    A performance engineering forum

  8. #8
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by malay_biswal
    I know what i'm. I do not need any goddamn comments on that front.
    relax man ... by the way, you might not be as brilliant as you think you are
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  9. #9
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    @haihello4you

    Ignore the nonsense going on in this thread. BTW what's the progress of your index addition?
    http://www.perf-engg.com
    A performance engineering forum

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width