Discussions
Oracle 19.7 (SE2) - SYSAUX growing because of WRI$_SQLSET_PLAN_LINES
Hi,
we have some Oracle 19.7 databases (SE2) but only in one of them the SYSAUX is growing too much.
It has now about 6GByte, the other databases have about 600MByte.
Reason:
MB | BLOCKS SEGMENT_NAME | SEGMENT_TYPE | TABLESPACE_NAME |
-------- ----------- ------------------------------ -------------------- --------------------
3,474 | 444696 SYS_LOB0000009212C00039$$ | LOBSEGMENT | SYSAUX |
1,088 | 139264 WRI$_SQLSET_PLAN_LINES | TABLE | SYSAUX |
We do not use sql_plan_baselines:
SQL> show parameter plan;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cell_offload_plan_display string AUTO
optimizer_adaptive_plans boolean FALSE
optimizer_capture_sql_plan_baselines boolean FALSE
optimizer_use_sql_plan_baselines boolean FALSE
resource_manager_plan string
3