Tablespace SYSAUX AUMENTANDO OFENSOR É A TABELA SQLOBJ$PLAN.
Hello, my SYXAUX tablespace is very large due to the SQLOBJ$PLAN table. For some reason, the retention setting is not working and the automatic cleanup is not happening.
I tried to delete it manually, but there are too many rows and it is taking too long to perform the cleanup and it often gives an error.
Here is the information:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.24.0.0.0
select min(timestamp),max(timestamp),count(*) from SQLOBJ$PLAN;
MIN(TIMES MAX(TIMES COUNT(*)
29-JUN-23 12-AUG-24 411471748
TABLESPACE_NAME SIZE_GB
SYSAUX 853.67GB
SELECT PARAMETER_NAME, PARAMETER_VALUE FROM DBA_SQL_MANAGEMENT_CONFIG where parameter_name='PLAN_RETENTION_WEEKS';