reseq.sql

select sequence_name, last_number from user_sequences where last_number >1 and sequence_name like 'SEQ%';