Thanks Rich for this MOS doc !
Best Regards,
Sourav Biswas
+91-9650017306
________________________________
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:
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!
Rich