Select count approximately

select num_rows from user_tables where table_name = 'XY'