关于oracle:批量修改sequence-cache

55次阅读

共计 388 个字符，预计需要花费 1 分钟才能阅读完成。

-- 批量批改 sequence cache
SELECT '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');

正文完