SAP Knowledge Base Article - Preview

3015523 - Huge space consumption of SM/OTHER in SYSAUX Tablespace

Symptom

SYSAUX is growing rapidly and most space is consumed by SM/OTHER.

SQL> SELECT occupant_name, space_usage_kbytes FROM V$SYSAUX_OCCUPANTS;

OCCUPANT_NAME
----------------------------------------------------------------
SPACE_USAGE_KBYTES
------------------
SM/AWR 3.872.448
SM/ADVISOR 2.369.920
SM/OPTSTAT 5.148.160
SM/OTHER 18.783.040


Read more...

Environment

  • Oracle RDBMS 19.7
  • SAP System indendent
  • Operating System independent

Product

SAP ERP 6.0

Keywords

oraclt, asts, SM/OTHER, AWR, 19.7, 19c, 19, space, consumption, Auto STS Capture Task, 19.8, RU, Release Update, SBP , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.