2 Replies Latest reply: Oct 17, 2012 12:03 AM by Osama_Mustafa RSS

    Active Session History (ASH) performed an emergency flush. This may mean th

    BahruzQasimov
      Active Session History (ASH) performed an emergency flush. This may mean that ASH is undersized. If emergency flushes are a recurring issue, you may consider increasing ASH size by setting the value of ASHSIZE to a sufficiently large value. Currently, ASH size is 67108864 bytes. Both ASH size and the total number of emergency flushes since instance startup can be monitored by running the following query:
      select total_size,awr_flush_emergency_count from v$ash_info;



      this my select


      TOTAL_SIZE AWR_FLUSH_EMERGENCY_COUNT
      ---------- -------------------------
      67108864

      How can increse this parameter ?

      Edited by: BahruzQasimov on Oct 16, 2012 9:23 PM

      Edited by: BahruzQasimov on Oct 16, 2012 9:26 PM