Query para verificar todas as sequences no banco:

select sequence_owner, sequence_name from dba_sequences;