Thanks Rich for this MOS doc !
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Rich J <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
Sent: Friday, August 30, 2019 6:33 PM
To: oracle-l@xxxxxxxxxxxxx <oracle-l@xxxxxxxxxxxxx>
Subject: Re: How to purge SYSAUX Tablespace (SQL_MANAGEMENT_BASE Occupant)
On 2019/08/30 06:51, Sourav Biswas wrote:
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.
MOS Doc 1499542.1 appears to have has your answer, along with the warnings for