                      END)    count_dbms_sql,
                COUNT(1)      count_total
         FROM   cdb_source
-        WHERE  owner NOT IN ( 'SYS', 'SYSTEM', 'OUTLN', 'AWR_STAGE',
-                              'CSMIG', 'CTXSYS', 'DBSNMP', 'DIP',
-                              'DMSYS', 'DSSYS', 'EXFSYS', 'LBACSYS',
-                              'MDSYS', 'ORACLE_OCM', 'ORDPLUGINS', 'ORDSYS',
-                              'PERFSTAT', 'TRACESVR', 'TSMSYS', 'XDB',
-                              'APEX_030200', 'SYSMAN', 'OLAPSYS', 'ORDDATA',
-                              'WMSYS', 'APPQOSSYS', 'FLOWS_FILES', 'OWBSYS',
-                              'SCOTT', 'SPATIAL_WFS_ADMIN_USR',
-                              'SPATIAL_CSW_ADMIN_USR'
-                              ,
-                                      'MGMT_VIEW',
-                              'APEX_PUBLIC_USER', 'ANONYMOUS', 'SQLTXPLAIN',
-                              'SQLTXADMIN',
-                              'TRCANLZR', 'HR', 'OE', 'SI_INFORMTN_SCHEMA',
-                              'XS$NULL', 'IX', 'OWBSYS_AUDIT', 'MDDATA',
-                              'SH', 'BI', 'PM' )
+        WHERE  owner NOT IN 
+                            (
+                            SELECT name
+                            FROM   SYSTEM.logstdby$skip_support
+                            WHERE  action=0)
         GROUP  BY '&&v_host'
                   || '_'
                   || '&&v_dbname'

               GROUPING(inmemory)                        IN_INMEMORY,
               ROUND(SUM(bytes) / 1024 / 1024 / 1024, 0) GB
        FROM   cdb_segments
        WHERE  owner NOT IN ( 'SYS', 'SYSTEM', 'OUTLN', 'AWR_STAGE',
                              'CSMIG', 'CTXSYS', 'DBSNMP', 'DIP',
                              'DMSYS', 'DSSYS', 'EXFSYS', 'LBACSYS',
                              'MDSYS', 'ORACLE_OCM', 'ORDPLUGINS', 'ORDSYS',
                              'PERFSTAT', 'TRACESVR', 'TSMSYS', 'XDB',
                              'APEX_030200', 'SYSMAN', 'OLAPSYS', 'ORDDATA',
                              'WMSYS', 'APPQOSSYS', 'FLOWS_FILES', 'OWBSYS',
                              'SCOTT', 'SPATIAL_WFS_ADMIN_USR', 'SPATIAL_CSW_ADMIN_USR', 'MGMT_VIEW',
                              'APEX_PUBLIC_USER', 'ANONYMOUS', 'SQLTXPLAIN', 'SQLTXADMIN',
                              'TRCANLZR', 'HR', 'OE', 'SI_INFORMTN_SCHEMA',
                              'XS$NULL', 'IX', 'OWBSYS_AUDIT', 'MDDATA',
                              'SH', 'BI', 'PM' )
        GROUP  BY grouping sets( ( ), ( con_id ), ( owner ), ( segment_type ),
                    ( tablespace_name ), ( flash_cache ), ( inmemory ), ( con_id, owner ), ( con_id, owner, flash_cache, inmemory ) )) a; 


       host,
       created
FROM   cdb_db_links
WHERE  owner NOT IN 
                     (
                     SELECT name
                     FROM   SYSTEM.logstdby$skip_support
                     WHERE  action=0);

spool off

