Re: How to purge SYSAUX Tablespace (SQL_MANAGEMENT_BASE Occupant)

From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Fri, 30 Aug 2019 08:03:35 -0500
Message-ID: <aca07f7d0c78a31acf651cd841ca22f8_at_society.servebeer.com>

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

--
http://www.freelists.org/webpage/oracle-l

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

This message: [ Message body ]
Next message: Lothar Flatz: "EM Express for Developers"
Previous message: Mladen Gogala: "Missing SPFILE"
In reply to Sourav Biswas: "How to purge SYSAUX Tablespace (SQL_MANAGEMENT_BASE Occupant)"
Next in thread: Sourav Biswas: "Re: How to purge SYSAUX Tablespace (SQL_MANAGEMENT_BASE Occupant)"
Reply: Sourav Biswas: "Re: How to purge SYSAUX Tablespace (SQL_MANAGEMENT_BASE Occupant)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message