SAP Knowledge Base Article - Preview

3259312 - SQL_MANAGEMENT_BASE occupies SYSAUX

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.