这是一个BUG，可以通过 truncate释放空间。

推荐的做法是先备份SQL Profile，以便你可能还需要它们。

STEP 1 – Pack all the profiles in the STAGING table. Export this staging table in case you need the backup

BEGIN
DBMS_SQLTUNE.CREATE_STGTAB_SQLPROF (table_name => ‘PROFILE_STGTAB’);
DBMS_SQLTUNE.PACK_STGTAB_SQLPROF ( profile_category => ‘%’
, staging_table_name => ‘PROFILE_STGTAB’
);
commit;
END;
/

STEP 2 – DROP BASELINES, PROFILES

truncate table sqllog$;
truncate table sql$;
truncate table sql$text;
truncate table sqlobj$;
truncate table sqlobj$auxdata;
truncate table sqlobj$data;

— These commands will clear up all the baselines and profiles.

STEP 3 – UNPACK YOUR PROFILES.

BEGIN
DBMS_SQLTUNE.UNPACK_STGTAB_SQLPROF( replace => FALSE
, staging_table_name => ‘PROFILE_STGTAB’);
commit;
END;
/