Database Administration (MOSC)

MOSC Banner

Tablespace SYSAUX AUMENTANDO OFENSOR É A TABELA SQLOBJ$PLAN.

edited Aug 15, 2024 6:30PM in Database Administration (MOSC) 3 commentsAnswered

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';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center