[Book Script] 거의 다 사용한 시퀀스 찾기

haisins

6년 ago

시퀀스 OWNER 를 넣고 USED 컬럼을 확인.

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 ;

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 ;