Database Tuning (MOSC)

MOSC Banner

Discussions

Oracle 19.7 (SE2) - SYSAUX growing because of WRI$_SQLSET_PLAN_LINES

edited Jul 17, 2020 5:29AM in Database Tuning (MOSC) 23 commentsAnswered ✓

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

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.

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center