SQLOBJ$PLAN table / SYSAUX growing out of bounds
Hello
We have a 19.13.0.0.0 database on our production exadata machines
The SYSAUX tablespace has grown a lot of late
The table SQLOBJ$PLAN table is 147 GB (93 GB LOB and 54 GB Data) and an index on it is 7.4 GB so a total of 154 GB
select sum(bytes)/1024/1024/1024 GB from dba_Segments where segment_name='SYS_LOB0018907224C00040$$';
GB
93.24
select sum(bytes)/1024/1024/1024 GB from dba_Segments where segment_name='SQLOBJ$PLAN';
GB
54.43
SQL> select sum(bytes)/1024/1024/1024 GB from dba_Segments where segment_type like '%INDEX%' and segment_name in
2 (select index_name from dba_indexes where table_name='SQLOBJ$PLAN');