<link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=7975199447131874550&zx=760534d9-1ce4-4510-a7d7-6a882e368569' media='none' onload='if(media!='all')media='all'' rel='stylesheet'/><noscript><link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=7975199447131874550&zx=760534d9-1ce4-4510-a7d7-6a882e368569' rel='stylesheet'/></noscript>
<meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/>
<meta name='google-adsense-platform-domain' content='blogspot.com'/>

<!-- data-ad-client=ca-pub-8669036782105267 -->

</head><body>

More

오라클 시퀀스 증가값 1로 설정했는데 20씩 올라가는 현상 해결방법

4월 10, 2023 - (Updated: 3월 15, 2024)

콜드카드

오라클에서 컬럼 넘버 증가값 사용을 위해 시퀀스를 설정했는데 시작값(MIN_VALUE)을 1로 설정하고 증가값을(INCREMENT_BY) 1로 설정했는데 한번에 20씩 증가하는 현상이 생기는 현상 해결방법입니다.

20씩 증가하는 시퀀스

테이블을 하나 만들면서 번호로 컬럼에 사용할 시퀀스를 하나 만들었습니다. 최소값 1에 증가값 1로 시작했는데 데이터를 몇번 NEXTVAL명령어로 넣다 보니 아래 그림처럼 현재 LAST_NUMBER 값이 121로 들어가있습니다.

20씩-시퀀스-증가

시퀀스 이상 증가값의 해결법

SQL Developer에서 확인해보니 캐시가 설정되어 있고 캐시 크기가 20으로 되어있는 걸 확인 할 수 있습니다. 이 캐시가 문제였던 걸로 캐시 크기만큼 증가값이 더해지는 증상입니다. 시퀀스를 만들때 캐시 부분을 설정하지 않았는데 아예 캐시 없음으로 설정해서 만들지 않으면 이렇게 나오는 것 같네요.

20값이 20으로 설정

지정하지 않았는데 캐시 크기가 20으로 되어있습니다

이 부분을 캐시 없음으로 변경해주면 증가값이 20씩 올라가지 않습니다.

캐시없음 설정

캐시 없음으로 바꿔줍니다

캐시 없음으로 바꾼 후 시퀀스를 실행해보니 INCREMENT_BY 설정값대로 1씩 올라가고 있습니다.

시퀀스-정상-증가

처음엔 103에서

시퀀스-정상-증가

실행 후 1씩 올라갑니다

Read Also

공유:

공유

관심 있을 만한 글:

<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/984859869-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY42-pIIoSe-mNmitNPfxaOYYWx-8Q:1732434582914';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d7975199447131874550','//cold-card.blogspot.com/2023/04/oracle-sequence-increments-by-20.html','7975199447131874550');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '7975199447131874550', 'title': '\ucf5c\ub4dc\uce74\ub4dc', 'url': 'https://cold-card.blogspot.com/2023/04/oracle-sequence-increments-by-20.html', 'canonicalUrl': 'https://cold-card.blogspot.com/2023/04/oracle-sequence-increments-by-20.html', 'homepageUrl': 'https://cold-card.blogspot.com/', 'searchUrl': 'https://cold-card.blogspot.com/search', 'canonicalHomepageUrl': 'https://cold-card.blogspot.com/', 'blogspotFaviconUrl': 'https://cold-card.blogspot.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': false, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'ko', 'localeUnderscoreDelimited': 'ko', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22\ucf5c\ub4dc\uce74\ub4dc - Atom\x22 href\x3d\x22https://cold-card.blogspot.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22\ucf5c\ub4dc\uce74\ub4dc - RSS\x22 href\x3d\x22https://cold-card.blogspot.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22\ucf5c\ub4dc\uce74\ub4dc - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/7975199447131874550/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22\ucf5c\ub4dc\uce74\ub4dc - Atom\x22 href\x3d\x22https://cold-card.blogspot.com/feeds/6635233804220753410/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-8669036782105267', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/d78375fb222d99b3', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': '\uacf5\uc720 \ub9c1\ud06c \ub9cc\ub4e4\uae30', 'key': 'link', 'shareMessage': '\uacf5\uc720 \ub9c1\ud06c \ub9cc\ub4e4\uae30', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Facebook\uc5d0 \uacf5\uc720', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'X\uc5d0 \uacf5\uc720', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Pinterest\uc5d0 \uacf5\uc720', 'target': 'pinterest'}, {'name': '\uc774\uba54\uc77c', 'key': 'email', 'shareMessage': '\uc774\uba54\uc77c', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27ko\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Read more \xbb', 'pageType': 'item', 'postId': '6635233804220753410', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQv25HdIfPNFONORwFBWxYlbDp2CfNNeuorLs7ibXsTx78aXg8yfCNq7bXCnXnuhvXNBejPJYpBKxdXkaxb8RaR8TMMZQDAt_Ah6F_rHfvclpVt50CLEiBkQxbdNqCeZnbDXK9aebFLTGyIQ3oNFeh8-zyGiArXOiNEuCKq5CvTlubaRqa7lBgDg/s72-w640-c-h522/%EC%9D%B4%EB%AF%B8%EC%A7%80%20013.png', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQv25HdIfPNFONORwFBWxYlbDp2CfNNeuorLs7ibXsTx78aXg8yfCNq7bXCnXnuhvXNBejPJYpBKxdXkaxb8RaR8TMMZQDAt_Ah6F_rHfvclpVt50CLEiBkQxbdNqCeZnbDXK9aebFLTGyIQ3oNFeh8-zyGiArXOiNEuCKq5CvTlubaRqa7lBgDg/w640-h522/%EC%9D%B4%EB%AF%B8%EC%A7%80%20013.png', 'pageName': '\uc624\ub77c\ud074 \uc2dc\ud000\uc2a4 \uc99d\uac00\uac12 1\ub85c \uc124\uc815\ud588\ub294\ub370 20\uc529 \uc62c\ub77c\uac00\ub294 \ud604\uc0c1 \ud574\uacb0\ubc29\ubc95', 'pageTitle': '\ucf5c\ub4dc\uce74\ub4dc: \uc624\ub77c\ud074 \uc2dc\ud000\uc2a4 \uc99d\uac00\uac12 1\ub85c \uc124\uc815\ud588\ub294\ub370 20\uc529 \uc62c\ub77c\uac00\ub294 \ud604\uc0c1 \ud574\uacb0\ubc29\ubc95', 'metaDescription': '\uc2dc\ud000\uc2a4 \uc99d\uac00\uac12\uc744 1\ub85c \uc124\uc815\ud588\ub294\ub370 \uce90\uc2dc\ub85c \uc778\ud574 20\uc529 \uc62c\ub77c\uac00\ub294 \uc99d\uc0c1\uc758 \ud574\uacb0 \ubc29\ubc95\uc785\ub2c8\ub2e4.'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': '\uc218\uc815', 'linkCopiedToClipboard': '\ub9c1\ud06c\ub97c \ud074\ub9bd\ubcf4\ub4dc\uc5d0 \ubcf5\uc0ac\ud588\uc2b5\ub2c8\ub2e4.', 'ok': '\ud655\uc778', 'postLink': '\uae00 \ub9c1\ud06c'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': '\uc0ac\uc6a9\uc790 \uc9c0\uc815', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': '\uc624\ub77c\ud074 \uc2dc\ud000\uc2a4 \uc99d\uac00\uac12 1\ub85c \uc124\uc815\ud588\ub294\ub370 20\uc529 \uc62c\ub77c\uac00\ub294 \ud604\uc0c1 \ud574\uacb0\ubc29\ubc95', 'description': '\uc2dc\ud000\uc2a4 \uc99d\uac00\uac12\uc744 1\ub85c \uc124\uc815\ud588\ub294\ub370 \uce90\uc2dc\ub85c \uc778\ud574 20\uc529 \uc62c\ub77c\uac00\ub294 \uc99d\uc0c1\uc758 \ud574\uacb0 \ubc29\ubc95\uc785\ub2c8\ub2e4.', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQv25HdIfPNFONORwFBWxYlbDp2CfNNeuorLs7ibXsTx78aXg8yfCNq7bXCnXnuhvXNBejPJYpBKxdXkaxb8RaR8TMMZQDAt_Ah6F_rHfvclpVt50CLEiBkQxbdNqCeZnbDXK9aebFLTGyIQ3oNFeh8-zyGiArXOiNEuCKq5CvTlubaRqa7lBgDg/w640-h522/%EC%9D%B4%EB%AF%B8%EC%A7%80%20013.png', 'url': 'https://cold-card.blogspot.com/2023/04/oracle-sequence-increments-by-20.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 6635233804220753410}}, {'name': 'widgets', 'data': [{'title': 'Template Code (Do not disable)', 'type': 'HTML', 'sectionId': 'settings', 'id': 'HTML3'}, {'title': '\ucf5c\ub4dc\uce74\ub4dc(\ud5e4\ub354)', 'type': 'Header', 'sectionId': 'header', 'id': 'Header1'}, {'title': 'category', 'type': 'LinkList', 'sectionId': 'section', 'id': 'LinkList1'}, {'title': '\ube14\ub85c\uadf8 \uac8c\uc2dc\ubb3c', 'type': 'Blog', 'sectionId': 'main', 'id': 'Blog1', 'posts': [{'id': '6635233804220753410', 'title': '\uc624\ub77c\ud074 \uc2dc\ud000\uc2a4 \uc99d\uac00\uac12 1\ub85c \uc124\uc815\ud588\ub294\ub370 20\uc529 \uc62c\ub77c\uac00\ub294 \ud604\uc0c1 \ud574\uacb0\ubc29\ubc95', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQv25HdIfPNFONORwFBWxYlbDp2CfNNeuorLs7ibXsTx78aXg8yfCNq7bXCnXnuhvXNBejPJYpBKxdXkaxb8RaR8TMMZQDAt_Ah6F_rHfvclpVt50CLEiBkQxbdNqCeZnbDXK9aebFLTGyIQ3oNFeh8-zyGiArXOiNEuCKq5CvTlubaRqa7lBgDg/w640-h522/%EC%9D%B4%EB%AF%B8%EC%A7%80%20013.png', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'Oleh'}, {'name': 'timestamp', 'label': 'pada tanggal'}, {'name': 'labels', 'label': ''}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'Post a Comment'}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'Oleh'}, {'name': 'timestamp', 'label': 'pada tanggal'}, {'name': 'labels', 'label': ''}, {'name': 'comments', 'label': 'Post a Comment'}]}, {'title': 'Advertisement', 'type': 'HTML', 'sectionId': 'top_ads', 'id': 'HTML90'}, {'title': 'Advertisement', 'type': 'HTML', 'sectionId': 'bottom_ads', 'id': 'HTML94'}, {'type': 'AdSense', 'sectionId': 'sidebar', 'id': 'AdSense1'}, {'title': '\ud0dc\uadf8', 'type': 'Label', 'sectionId': 'sidebar', 'id': 'Label1'}, {'title': 'Table of Contents', 'type': 'HTML', 'sectionId': 'toc_auto', 'id': 'HTML8'}]}]);
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML3', 'settings', document.getElementById('HTML3'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'header', document.getElementById('Header1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList1', 'section', document.getElementById('LinkList1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'main', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/610513206-lbx__ko.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/1964470060-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML90', 'top_ads', document.getElementById('HTML90'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML94', 'bottom_ads', document.getElementById('HTML94'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_AdSenseView', new _WidgetInfo('AdSense1', 'sidebar', document.getElementById('AdSense1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label1', 'sidebar', document.getElementById('Label1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML8', 'toc_auto', document.getElementById('HTML8'), {}, 'displayModeFull'));
</script>
</body>