Re: How to purge SYSAUX Tablespace (SQL_MANAGEMENT_BASE Occupant)

From: Rich J <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Fri, 30 Aug 2019 08:03:35 -0500

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

Follow-Ups:
- Re: How to purge SYSAUX Tablespace (SQL_MANAGEMENT_BASE Occupant)
  - From: Sourav Biswas

References:
- How to purge SYSAUX Tablespace (SQL_MANAGEMENT_BASE Occupant)
  - From: Sourav Biswas

Other related posts:

» How to purge SYSAUX Tablespace (SQL_MANAGEMENT_BASE Occupant)- Sourav Biswas
» Re: How to purge SYSAUX Tablespace (SQL_MANAGEMENT_BASE Occupant) - Rich J
» Re: How to purge SYSAUX Tablespace (SQL_MANAGEMENT_BASE Occupant)- Sourav Biswas