Symptom
Tablespace SYSAUX increases abnormally and is mainly occupied by SQL_MANAGEMENT_BASE.
SQL> SELECT occupant_name, space_usage_kbytes FROM V$SYSAUX_OCCUPANTS;
OCCUPANT_NAME
----------------------------------------------------------------
SPACE_USAGE_KBYTES
------------------
SQL_MANAGEMENT_BASE
12345
Read more...
Environment
Oracle version
11.2.0.2
11.2.0.1
11.1.0.7
Keywords
SQL_MANAGEMENT_BASE, optimizer_capture_sql_plan_baselines, SYSAUX increase , 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.