For an Oracle database, select the (possibly stale) table row counts from all_tab_statistics for all tables with a given field name and owner. This example is based on the Oracle Transportation Management (OTM) schema and shows all table row counts for tables with a domain_name field.

get_table_row_counts_by_field_name.sql

SELECT table_name, num_rows, last_analyzed
  FROM all_tab_statistics
  WHERE table_name IN (SELECT table_name 
    FROM all_tab_cols
    WHERE column_name = 'DOMAIN_NAME'
      AND owner IN ('GLOGOWNER'))
  ORDER BY num_rows DESC;