May I know what is the difference between awr and ash?
Kindly share your valuable thoughts,
Thanks in advance,
ASH - It can help you when there's a sudden performance degradation of the database felt. Storage is not persistent and as time progresses, the old entries are removed to accommodate new ones. They can be viewed using V$ACTIVE_SESSION_HISTORY.
AWR - It holds historic past snapshot intervals and the session performance statistics for analysis later.
ASH report provides the following information:
AWR reports provide the following information:
Sign up for STechies