시퀀스 OWNER 를 넣고 USED 컬럼을 확인.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
SQL> SELECT SEQUENCE_OWNER "OWNER", SEQUENCE_NAME "SEQUENCE", MIN_VALUE "MIN VALUE", MAX_VALUE "MAX VALUE", INCREMENT_BY "INCREASE", CYCLE_FLAG "CYCLE", ORDER_FLAG "ORDER", CACHE_SIZE "CACHE", LAST_NUMBER "LAST NUMBER", ROUND((LAST_NUMBER/MAX_VALUE)*100) "USED" FROM DBA_SEQUENCES WHERE SEQUENCE_OWNER IN ('HR') ORDER BY 10 DESC ; |
This web site is really a walk-through for all of the info you wanted about this and didn’t know who to ask. Glimpse here, and you’ll definitely discover it.