How to clear SYSAUX space consumption by WRI$_SQLSET_PLAN_LINES (Doc ID 2857648.1)

Last updated on NOVEMBER 03, 2022

Applies to:

Symptoms

Database Version: 19.13

The 'occupant' of sysaux called SM/OTHER is taking up over 200gb. 

(1b) SYSAUX occupants space usage (v$sysaux_occupants)
********************************************************
|
| Occupant Name Schema Name Space Usage
| -------------------- -------------------- ----------------
| SM/OTHER SYS 203,007.2 MB >>>>>>>>>>>>>>Almost 200 GB by SM/OTHER
| SM/AWR SYS 26,136.7 MB
| XDB XDB 62.9 MB
| SM/ADVISOR SYS 38.8 MB

**********************************
(4) Space usage by non-AWR components (> 500K)
**********************************

COMPONENT MB SEGMENT_NAME SEGMENT_TYPE
--------- --------- --------------------------------------------------------------------- ---------------
NON_AWR ######### SYS.WRI$_SQLSET_PLAN_LINES TABLE >>>>>>>>>>>>>>>>>>>>>Most of the space consumption by WRI$_SQLSET_PLAN_LINES

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.