Buscar secuencas en la base de datos

select * from all_sequences
where
--sequence_owner='RRRRR' and
sequence_name like upper('%ZZZZZZZ%')
order by sequence_owner, sequence_name ;