Purging SYSAUX

In continuation to my previous post "SYSAUX Growing Rapidly" , here i wanted to present the second method of purging sysaux. Basically i tried to perform the steps as mentioned in previous post and drop_snapshot_range was taking too long (> 24hrs) and still running on test db.Again WRH$_ACTIVE_SESSION_HISTORY was in top of the list occupying … Continue reading Purging SYSAUX

Advertisement