Huge number of SQL_PLAN_DIRECTIVES with no owner.
For one of my CT there are very large number of SQL Plan Directives which are created and CT wants to drop all of them.
He is trying to follow below note.
Script to Bulk Drop SQL Plan Directives (Doc ID 2323144.1)
But he is seeing huge number of SPD with no owner.
SQL> select count(distinct directive_id) spd_count,owner from dba_sql_plan_dir_objects group by owner;
 SPD_COUNT OWNER
---------- --------------------
    158044 PANMDM
 116277434<<<<<<<<<<<<<<<<<<<<<<<<
   1384792 PAN_CDM_ETL
       247 SYSTEM
     90596 PAN_CDM_STG
 46 FLOWS_FILES
 24 OUTLN
     13250 PAN_CDM_DATA
       279 PAN_CDM_DATA_HISTORY
 16 XDB
 114524262 CDM_IRIS
      9214 APEX_050100
 32 DBSNMP
 1 ORDS_METADATA