Database - RAC/Scalability (MOSC)

MOSC Banner

Reclaim sysaux content of SQL plan baselines

edited Jul 19, 2019 10:44AM in Database - RAC/Scalability (MOSC) 2 commentsAnswered ✓

Hi

How I can reclaim 12c SQL Baseline space in SYSAUX. I disabled baseline evolution and cleared all baseline which was existing, but still space is not released.

SQL> SELECT SQL_HANDLE FROM DBA_SQL_PLAN_BASELINES;

no rows selected

SQL> select OCCUPANT_NAME, SPACE_USAGE_KBYTES/1024/1024 "size in GB" from V$SYSAUX_OCCUPANTS where OCCUPANT_NAME='SQL_MANAGEMENT_BASE';

OCCUPANT_NAME                  size in GB

------------------------------ ----------

SQL_MANAGEMENT_BASE             73.321106

SQL>

Regards

Steve

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center