Do a self join - should run faster than PL SQL:

select count(a.rowid) from cust a, cust b
where a.fname = b.fname

This should give all rows with same fname. try.