        index_type,
        COUNT(1)
 FROM   cdb_indexes
-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'

                                      'OTHERS')         segment_type,
               TRUNC(SUM(a.bytes) / 1024 / 1024 / 1024) total_gb
        FROM   cdb_segments a
        WHERE  a.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 a.con_id,
                  a.owner,
                  DECODE(a.segment_type, 'TABLE', 'TABLE',

                       AND t.table_name = s.segment_name
                       AND t.subpartition_name = s.partition_name
                       AND compression = 'ENABLED'
                       AND t.table_owner NOT IN 
                                                 (
                                                 SELECT name
                                                 FROM   SYSTEM.logstdby$skip_support
                                                 WHERE  action=0)
                GROUP  BY t.con_id,
                          t.table_owner,
                          t.compress_for)
