Database Administration (MOSC)

MOSC Banner

oracle sequence

edited May 31, 2018 12:14PM in Database Administration (MOSC) 8 commentsAnswered ✓

I need query to find list of sequence which has less than 20% of sequence numbers. 

SQL what % used the sequence is, e.g. take curr value of the sequence, take the max val and work out the remaining amount, then divide by the total to get the % usedSQL what % used the sequence is, e.g. take curr value of the sequence, take the max val and work out the remaining amount, then divide by the total to get the % used

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center