I usually fetch a single random row this way:

SELECT column 
  FROM table
  WHERE COLUMN_VALUE = 'Y' -- value of COLUMN_VALUE
  ORDER BY dbms_random.value
  FETCH FIRST 1 ROWS ONLY;

And according to this blog post it should be good in terms of performance "in Oracle Database 19c and onwards".