Re: How to purge SYSAUX Tablespace (SQL_MANAGEMENT_BASE Occupant)

From: Rich J <>
Date: Fri, 30 Aug 2019 08:03:35 -0500
Message-ID: <>

On 2019/08/30 06:51, Sourav Biswas wrote:

> Hi All,
> What is the fastest and safest way to Purge SYSAUX tablespace. Currently it has grown to ~ 1tb in size. Please suggest as SQL_MANAGEMENT_BASE occupant needs to be released. Currently we have disabled automatic baseline gather. Its retention is 53 weeks.
> Please suggest.

MOS Doc 1499542.1 appears to have has your answer, along with the warnings for those actions.

Good luck!


Received on Fri Aug 30 2019 - 15:03:35 CEST

Original text of this message