Oracle Sequences

I found several good articles about Oracle Sequences:


Oracle Sequences 
1. What sequences are being used, and do they roll over or run out?
SELECT cycle_flag, sequence_name FROM ALL_SEQUENCES;
2. Which sequences are being used as primary keys?

3. Which sequences are in danger of running out?
4. What happens when a sequence runs out?


How to Create Auto Increment Columns in Oracle