hi,
i have one production database in that sysaux tablespace size was 80Gb due to statistics_level=ALL now we had change to typical after that 75Gb space get free but we can not resize this datafiles because database was scatterd what we need to do to shrink this tablespace as well as datafile;
now only 3GB of size used in 80GB tablespace.
what action we need to take to shrink the tablespace as well as files
Thanks .