Question about AWR
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Question about AWR

  1. #1
    Join Date
    Oct 2009
    Posts
    2

    Question about AWR

    I am preparing for OCA/OCP .... What should be the BEST answer for this question...

    Question: In which situation would you use an AWR Active Session History Report?

    a. If users are unable to create sessions.
    b. If you want to view results of an ADDM Analysis
    c. If users report that the system response time was slow during a specific time period and you suspect that performance configuration changes might be the cause
    d. If users report the system response time was slow between 4.00 PM and 4.00 AM, but ADDM analysis for that time period shows no performance issues.
    Last edited by Faire; 10-05-2009 at 02:23 PM.

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,480

    Talking Ac/dc?

    c & d maybe?
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Oct 2009
    Posts
    2
    Thanks for the reply. There is only ONE answer.

    I think it is C but not sure... Any Ideas???

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,480

    Cool AWR trick.

    Seems to be a trick question. Both c & d refer to a time period: "specific period of time" & "between 4.00 PM and 4.00 AM".
    The catch is that d refers to addm showing no performance issues.

    Yes, you are right, definitely it's "c".

    We award you an A+
    Good Luck!

    PS: I have been working with Grid Control using AWR for some 3 years now and I don't recall seeing any "Active Session History Report".
    Last edited by LKBrwn_DBA; 10-05-2009 at 05:23 PM.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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