Databases with flashback not turned on

  SELECT m.target_name,
         t.type_qualifier4 AS Role,
         m.column_label AS Flashback,
         m.VALUE AS Status
    FROM mgmt$metric_current m, mgmt$target t
   WHERE     m.metric_label = 'Flash Recovery'
         AND m.column_label = 'Flashback On'
         AND m.VALUE = 'NO'
         AND m.target_name LIKE '%PRD%'
         AND t.type_qualifier4 IN ('Primary', 'Physical Standby')
         AND t.target_name = m.target_name
         AND t.target_guid = m.target_guid
ORDER BY t.type_qualifier4, m.VALUE