Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sequences Nearing max limit

Sarat_yahooJun 7 2016 — edited Jun 7 2016

Hello All ,

Version : 11.2.0.4

We have 1500 sequence in our production database - So now i need to determine what are the sequences names that are nearing to max limit. I can able to view only single sequence with below query.

SELECT sequence_owner,

sequence_name,

last_number,

max_value,

cache_size

FROM dba_sequences  where sequence_name='ACCESS_CODE_NVL'

But i want a single query, when a sequence is within 5000 of reaching the maxvalue. If anyone have scripit or query i handy it would be more helpful.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2016
Added on Jun 7 2016
#general-database-discussions
12 comments
4,384 views