Tag Archives: sequence

Oracle Sequence Close to Maximum

This SQL identifies Oracle sequences that are above 90% used:

select sequence_owner "Owner", sequence_name "Name", last_number "Last", max_value "Max", last_number/max_value*100 "Pct Used" 
from dba_sequences
where sequence_owner not in ('SYS')
and last_number/max_value*100 < 101 and last_number/max_value*100 > 90
order by "Pct Used" desc