Database Tuning (MOSC)

MOSC Banner

Increase ASH to more that 254m on 12c

edited Aug 4, 2020 5:00AM in Database Tuning (MOSC) 2 commentsAnswered ✓

Dear Friends

We are having the famous "Active Session History (ASH) performed an emergency flush" log and the current size of ASH and Emergency flush count is

select total_size,awr_flush_emergency_count from v$ash_info;

TOTAL_SIZE AWR_FLUSH_EMERGENCY_COUNT

---------- -------------------------

266338304                        30

As this is a oracle 12c installation and per 1385872.1, it is possible to increase the _ASH_SIZE to more that 254M. But when I try to set _ASH_SIZE to more that 254M I always get

alter system set "_ASH_SIZE"=512M

*

ERROR at line 1:

ORA-02097: parameter cannot be modified because specified value is invalid

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center