Hi Expert
My database 11.2.0.3 in AIX
Getting the following errors in alert.log
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 _ASH_SIZE to a sufficiently large value. Currently, ASH size is 266338304 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;
Then I tried increase the value and getting error
SQL> alter system set _ash_size=512m;
alter system set _ash_size=512m
*
ERROR at line 1:
ORA-00911: invalid character