1 Reply Latest reply: Mar 9, 2013 6:28 PM by Mark D Powell RSS

    History tables

    user511621
      HI - I am using oracle 10g database and awr retention is 30 days and snapshot interval is default 1 hr. database is geeting bounced everyday

      I this possible to get the below details for last 10 days using sql queries from history tables ?

      Load profile
      Workload Repository Views
      top 5 wait events
      top segments.
        • 1. Re: History tables
          Mark D Powell
          Yes. You can run AWR reports providing your site has purchased the extra cost EM Diagonstic Pack license for snapshots taken before the bounce and for periods where the snapshots occurred after the bounce. Just do not try to run a report across a bounce.

          You can also query AWR table directly if you have queries to obtain the specific information you are interested in.

          HTH -- Mark D Powell --