{1 - 24} GreyGrey
{25 - 49} GreenGreen
{50 - 499} BlueBlue
{500 - 4999} OrangeOrange
{5000 - 24999} RedRed
{25000+} BlackBlack

Please confirm that you would like to report this for an admin to review.


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

Oracle Consultant needs help regarding “Active Session History (ASH) performed an emergency flush. This may mean th”



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


Consultant, needs help regarding Active Session History (ASH) performed an emergency flush. This may mean thHelp!

Oracle Discussion Forums : Thread List – Oracle Database



Confirm that you would like to Remove Email Alerts for your question. You cant undo this and you will not be able to re-subscribe.


Tags

No Answers

You must be Logged In to Answer this Question

Already a Member, Log In
Not a member yet? Sign Up

Categories

Sponsors


oracle forum