WITH 
  tabs AS (
     SELECT /*+ materialize */ object_name AS table_name
       FROM user_objects
      WHERE object_type = 'TABLE'
        AND generated = 'N'
   ),
   hist_tabs AS (
      SELECT /*+ materialize */ table_name
        FROM user_tab_cols
       WHERE column_name = 'VT$'
         AND hidden_column = 'YES'
   ),
   pk_tabs AS (
      SELECT /*+ materialize */ table_name 
        FROM all_constraints
        WHERE constraint_type = 'P' AND owner = USER
   )
SELECT /*+ordered use_hash(tabs) use_hash(hist_tabs) use_has(pk_tabs) */ tabs.table_name
  FROM tabs
  JOIN pk_tabs ON pk_tabs.table_name = tabs.table_name 
  LEFT JOIN hist_tabs ON hist_tabs.table_name = tabs.table_name
 WHERE hist_tabs.table_name is NULL
 ORDER BY tabs.table_name