There are multiple ways to avoid the vast amounts of data in the SYSAUX tablespace created by the AUTO_STATS_ADVISOR_TASK. This advisor runs during a maintenance window, and stores its history in the “SM/ADVISOR” class of segments in SYSAUX. Zero That’s a proper way to get rid of it, and to implicitly truncate all the data […]
About
Martin Klier
Troubleshooter, Database integration, performance and HA specialist with 15+ years of experience. Oracle ACE Director.
co-founder of performing databases.
Your data efficiency experts.
