Database load fails with error 'Active Session History performed an emergency flush'

Document ID : KB000028451
Last Modified Date : 14/02/2018
Show Technical Document Details

You are migrating an eHealth database to a new VM with a fresh installation of eHealth 6.3.2.x, but the load fails and generates the following error:

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 2097152 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;

At this point the nhLoadDb command may appear to hang.

This may mean that ASH is undersized. In fact, our experience has shown that in the case of a database load to a new VM, the root cause of the error is a misconfiguration of CPUs; customers may accidentally allocate only one CPU to the VM, which is well below specifications.

How to Fix:

  1. If necessary, cancel out of the hung load process
  2. Destroy the partially loaded database with nhDestroyDb -s {SID} (and reboot server if Windows)
  3. Reconfigure the VM with the appropriate number of CPUs (we recommend 8 or more)
  4. Create a new database with nhCreateDb
  5. Load the database backup with nhLoadDb