My Oracle Support Banner

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

Last updated on NOVEMBER 03, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 19.13.0.0.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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