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.
SAP Knowledge Base Article - Preview