Modify the sequence cache in bulk

- change the sequence batch cache SELECT 'the alter sequence' | | SEQUENCE_OWNER | | '. '| | SEQUENCE_NAME | |' cache. 1000; ' INC_SEQ_CMD FROM DBA_SEQUENCES WHERE LAST_NUMBER > 100000 AND CACHE_SIZE < 200 AND SEQUENCE_OWNER IN (SELECT USERNAME FROM DBA_USERS WHERE ACCOUNT_STATUS = 'OPEN' AND USERNAME NOT IN ('SYS', 'SYSTEM', 'ZABBIX', 'DBSNMP', 'MGMT_VIEW', 'SYSMAN')) AND EXISTS (SELECT 1 FROM V$DATABASE WHERE OPEN_MODE = 'READ WRITE' AND DATABASE_ROLE = 'PRIMARY');