shrink sysaux datafile
Here is using 11.2.0.4 database and having sysaux tablespace with 1 file. Now the file is already 3GB
I detele some snapshot, and try to alter table WRH$* allow row movement and shrink cascade. But still can't move the HWM of the datafile.
Are there any way to shrink to datafile of sysaux??
FILE_NAME FILE_ID BLOCK_ID SIZEMB Name Position MB
-------------------------------- ---------- ---------- ---------- -------------------------------------------------- -----------
/mydbdata/sysaux01.dbf 2 392192 156 Free 3064
/mydbdata/sysaux01.dbf 2 392064 1 SYS.WRH$_EVENT_HISTOGRAM 3063
/mydbdata/sysaux01.dbf 2 392040 .1875 Free 3062.8125
/mydbdata/sysaux01.dbf 2 392032 .0625 SYS.WRH$_OSSTAT_PK 3062.75
/mydbdata/sysaux01.dbf 2 392024 .0625 SYS.WRH$_LATCH_MISSES_SUMMARY 3062.6875
/mydbdata/sysaux01.dbf 2 392016 .0625 SYS.WRH$_SEG_STAT_PK 3062.625