Analysis of historical sort usage
How to analyze the history of sorting operations and temporary tablespace scans in oracle database? If there is a heavy sort which happened a week ago and AWR retention is more than 7 days, then it is feasible to peep through the historic sort usage to either proactively tune the temporary area performance or to reactively tune the queries.
Please subscribe the channel for more interesting videos!