Database Administration (MOSC)

MOSC Banner

shrink sysaux datafile

edited Dec 5, 2017 9:55AM in Database Administration (MOSC) 21 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center