SQL> set autotrace on statistics
SQL> set timing on
<third run>		
SQL> SELECT distinct owner, table_name
  2  FROM all_my_tab_col_stats
  3       		  WHERE
  4       		        owner not in ('SYS','SYSMAN','SYSTEM','OUTLN','TSMSYS','DBSNMP','WMSYS','EXFSYS','CTXSYS','DMSYS','XDB','MDSYS','ORDSYS','OLAPSYS')
  5       		  GROUP BY owner, table_name
  6         		  HAVING  SUM(case WHEN histogram = 'FREQUENCY' THEN  1 ELSE 0 END) > 0 AND
  7         		         SUM(case WHEN NUM_NULLS > 0 THEN  1 ELSE 0 END) > 0 AND
  8         		         SUM(case WHEN avg_col_len > 25 THEN 1 ELSE 0 END) > 0;

OWNER                          TABLE_NAME                                       
------------------------------ ------------------------------                   
<output snipped>

Elapsed: 00:00:00.56

Statistics
----------------------------------------------------------                      
          0  recursive calls                                                    
          0  db block gets                                                      
       1593  consistent gets                                                    
       1590  physical reads                                                     
          0  redo size                                                          
        495  bytes sent via SQL*Net to client                                   
        420  bytes received via SQL*Net from client                             
          2  SQL*Net roundtrips to/from client                                  
          0  sorts (memory)                                                     
          0  sorts (disk)                                                       
          1  rows processed