Re: How to purge SYSAUX Tablespace (SQL_MANAGEMENT_BASE Occupant)
From: Sourav Biswas <biswas.sourav_at_hotmail.com>
Date: Sat, 31 Aug 2019 08:46:16 +0000
Message-ID: <BM1PR0101MB13946E12ABF707F91B4ECED7F0BC0@BM1PR0101MB1394.INDPRD01.PROD.OUTLOOK.COM>
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Rich J <rjoralist3_at_society.servebeer.com> Sent: Friday, August 30, 2019 6:33 PM
To: oracle-l_at_freelists.org <oracle-l_at_freelists.org> Subject: Re: How to purge SYSAUX Tablespace (SQL_MANAGEMENT_BASE Occupant)
Date: Sat, 31 Aug 2019 08:46:16 +0000
Message-ID: <BM1PR0101MB13946E12ABF707F91B4ECED7F0BC0@BM1PR0101MB1394.INDPRD01.PROD.OUTLOOK.COM>
Thanks Rich for this MOS doc !
Best Regards,
Sourav Biswas
+91-9650017306
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Rich J <rjoralist3_at_society.servebeer.com> Sent: Friday, August 30, 2019 6:33 PM
To: oracle-l_at_freelists.org <oracle-l_at_freelists.org> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Aug 31 2019 - 10:46:16 CEST