Oracle 11g: "With Clause" very slow
Try the hint INLINE

with abc as 
(
  select /*+ INLINE */ count(distinct id) as my_count, some_column
  from  large_view v where some_column in (...constant values here...)
  group by some_column
) select my_count from abc;