๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
[Redis] ‘RDB’ ํฌ๋งท์˜ ํŒŒ์ผ์˜ ๋‚ด์šฉ์„ ํ™•์ธํ•  ์ˆ˜ ์žˆ๋Š” ๋ฐฉ๋ฒ• RDB ํŒŒ์ผ ํฌ๋งท์ด๋ž€? RDB ํฌ๋งท์˜ ํŒŒ์ผ์€ Redis DataBase์˜ ์•ฝ์ž๋กœ Redis ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์—์„œ ์‚ฌ์šฉํ•˜๋Š” ํŒŒ์ผ ํ˜•์‹์ž…๋‹ˆ๋‹ค. Redis ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋Š” RDB(Redis DataBase) ํ˜•์‹์˜ ํŒŒ์ผ์„ ์‚ฌ์šฉํ•˜์—ฌ ๋ฐ์ดํ„ฐ๋ฅผ ์ €์žฅํ•ฉ๋‹ˆ๋‹ค. RDB ํŒŒ์ผ์€ Redis ์„œ๋ฒ„์—์„œ ๋ฐ์ดํ„ฐ I/O์— ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค. RDB ํŒŒ์ผ์€ Redis ๋ฐ์ดํ„ฐ์˜ ๋‚ด๋ถ€ ํ‘œํ˜„์„ ์ง๋ ฌํ™”ํ•˜์—ฌ ์ €์žฅํ•˜๋Š” ์ด์ง„ ํ˜•์‹์˜ binary ํŒŒ์ผ์ž…๋‹ˆ๋‹ค. Redis๋Š” RDB ํŒŒ์ผ์„ ์ƒ์„ฑํ•˜์—ฌ Redis ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์˜ ์Šค๋ƒ…์ƒท์„ ์ €์žฅํ•˜๊ณ , ๋‚˜์ค‘์— RDB ํŒŒ์ผ์„ ๋กœ๋“œํ•˜์—ฌ Redis ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ฅผ ๋ณต์›ํ•ฉ๋‹ˆ๋‹ค. ๐Ÿ“ ์ด์ง„ํŒŒ์ผ = ๋ฐ”์ด๋„ˆ๋ฆฌ(binary) ํŒŒ์ผ ์ด์ง„ ํŒŒ์ผ์€ ์ปดํ“จํ„ฐ์—์„œ ์‚ฌ์šฉ๋˜๋Š” ๋ชจ๋“  ๋ฐ์ดํ„ฐ๋ฅผ ํฌํ•จํ•˜๋Š” ํŒŒ์ผ ํ˜•์‹์„ ์˜๋ฏธํ•ฉ๋‹ˆ๋‹ค. ์ด์ง„ ํŒŒ์ผ์€ ๋ณดํ†ต ํ…์ŠคํŠธ ํŒŒ์ผ๊ณผ .. 2023. 3. 7.
DBMS์™€ ๊ธฐ์–ต์žฅ์น˜์˜ ๊ด€๊ณ„ ๋ฐ ๋ฉ”๋ชจ๋ฆฌ ํ™œ์šฉ ๊ธฐ์–ต์žฅ์น˜๋Š” ๊ธฐ์–ต ๋น„์šฉ์— ๋”ฐ๋ผ 1์ฐจ~3์ฐจ ๊ณ„์ธต์œผ๋กœ ๋ถ„๋ฅ˜ํ•  ์ˆ˜ ์žˆ๋‹ค. ๊ธฐ์–ต ๋น„์šฉ์ด๋ž€ '๋ฐ์ดํ„ฐ๋ฅผ ์ €์žฅํ•˜๋Š”๋ฐ ์†Œ๋ชจ๋˜๋Š” ๋น„์šฉ'์ด๋‹ค. ๊ทธ๋ฆผ - ๊ธฐ์–ต์žฅ์น˜์˜ ๊ณ„์ธต ๊ทธ๋ฆผ์˜ ํ”ผ๋ผ๋ฏธ๋“œ์—์„œ ์•„๋ž˜๋กœ ๊ฐˆ์ˆ˜๋ก ๋ฉด์ ์ด ์ปค์ง€๋Š” ๊ฒƒ์€ ๊ฐ™์€ ๋น„์šฉ์œผ๋กœ ์ €์žฅํ•  ์ˆ˜ ์žˆ๋Š” ๋ฐ์ดํ„ฐ ์šฉ๋Ÿ‰์ด ํฌ๋‹ค๋Š” ๊ฒƒ์„ ๋‚˜ํƒ€๋‚ธ๋‹ค. ๊ทธ๋Ÿฌ๋‚˜ ๊ธฐ์–ต ๋น„์šฉ์ด ๋‚ฎ์„์ˆ˜๋ก ๋ฐ์ดํ„ฐ ์ ‘๊ทผ ์†๋„๊ฐ€ ๋Š๋ ค์ง„๋‹ค. ๋งŽ์€ ๋ฐ์ดํ„ฐ๋ฅผ ์ €์žฅํ•˜๋ ค ํ•˜๋ฉด ์†๋„๋ฅผ ์žƒ๊ณ , ์†๋„๋ฅผ ์–ป๊ณ ์ž ํ•˜๋ฉด ๋งŽ์€ ๋ฐ์ดํ„ฐ๋ฅผ ์ €์žฅํ•˜๊ธฐ ํž˜๋“ค๋‹ค๋Š” ํŠธ๋ ˆ์ด๋“œ ์˜คํ”„๊ฐ€ ๋ฐœ์ƒํ•œ๋‹ค. DBMS๋Š” ๋ฐ์ดํ„ฐ ์ €์žฅ์„ ๋ชฉ์ ์œผ๋กœ ํ•˜๋Š” ๋ฏธ๋“ค์›จ์–ด์ด๋ฏ€๋กœ ๊ธฐ์–ต์žฅ์น˜์™€ ๋ฐ€์ ‘ํ•œ ๊ด€๊ณ„๊ฐ€ ์žˆ๋‹ค. DBMS๊ฐ€ ์‚ฌ์šฉํ•˜๋Š” ๋Œ€ํ‘œ์ ์ธ ๊ธฐ์–ต์žฅ์น˜๋Š” HDD(ํ•˜๋“œ๋””์Šคํฌ), ๋ฉ”๋ชจ๋ฆฌ์ด๋‹ค. ์šฉ๋Ÿ‰, ๋น„์šฉ, ์„ฑ๋Šฅ์ƒ์˜ ์ด์ ๋•Œ๋ฌธ์— DBMS์˜ ๋ฐ์ดํ„ฐ ์ €์žฅ ๋งค์ฒด๋กœ HDD๊ฐ€ ๋งŽ์ด ์‚ฌ์šฉ๋œ๋‹ค. ๋ฉ”๋ชจ๋ฆฌ๋Š” HD.. 2021. 9. 28.
๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์˜ ๊ธฐ๋ณธ ๊ตฌ์กฐ, ๊ฐœ๋… ๋ฐ ์šฉ์–ด ์ •๋ฆฌ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค VS DBMS Oracle, MySQL๊ณผ ๊ฐ™์€ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์†Œํ”„ํŠธ์›จ์–ด๋ฅผ '๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค'๋ผ๊ณ  ํ”ํžˆ ๋ถ€๋ฅด๋Š”๋ฐ ์ •ํ™•ํžˆ ๊ตฌ๋ถ„ํ•˜์ž๋ฉด DBMS(DataBase Management System)๊ฐ€ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์†Œํ”„ํŠธ์›จ์–ด๋ฅผ, ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋Š” DBMS๋กœ ์ƒ์„ฑ๋˜๊ณ  ์กฐ์ž‘๋˜๋Š” ์ €์žฅ๊ณต๊ฐ„์„ ๋งํ•œ๋‹ค. RDB(Relational Database)๋Š” DBMS์˜ ์ผ์ข…์ด๋‹ค. Oracle, Microsoft SQL Server, DB2, PostgreSQL, MySQL ๋“ฑ์ด ๋งŽ์ด ์‚ฌ์šฉ๋œ๋‹ค. ์ด RDB๋Š” ๊ฐ๊ฐ์˜ ํŠน์ง•์ด ์žˆ๊ณ  ๋‚ด๋ถ€ ์•„ํ‚คํ…์ฒ˜๊ฐ€ ์กฐ๊ธˆ์”ฉ ๋‹ค๋ฅด์ง€๋งŒ ๊ฒฐ๊ตญ RDB๋กœ์จ ๊ธฐ๋Šฅ์„ ์ œ๊ณตํ•œ๋‹ค๋Š” ๋ชฉ์ ์€ ๋ชจ๋‘ ๋™์ผํ•˜๋ฏ€๋กœ ๊ธฐ๋ณธ์ ์ธ ๊ตฌ์กฐ๋Š” ์œ ์‚ฌํ•˜๋‹ค. DBMS ์•„ํ‚คํ…์ฒ˜ ์‚ฌ์šฉ์ž(์–ดํ”Œ๋ฆฌ์ผ€์ด์…˜ ์‚ฌ์šฉ์ž, ๊ฐœ๋ฐœ์ž)์—๊ฒŒ์„œ ์ž…๋ ฅ๋œ SQL ๊ตฌ๋ฌธ์€ ์ค‘๊ฐ„์— ์žˆ๋Š”.. 2021. 9. 18.
Oracle WITH ๊ตฌ๋ฌธ์„ MySQL๋กœ ๋ณ€ํ™˜ํ•˜๊ธฐ Oracle WITH ๊ตฌ๋ฌธ์„ MySQL๋กœ ๋ณ€ํ™˜ํ•˜๊ธฐ MySQL 8.0 ์ด์ „ ๋ฒ„์ „์—์„œ๋Š” WITH ๊ตฌ๋ฌธ์ด ์ง€์›๋˜์ง€ ์•Š๊ธฐ ๋•Œ๋ฌธ์— WITH ๊ตฌ๋ฌธ์„ ๋ณ€ํ™˜ํ•˜๋ ค๋ฉด ๋‹ค์Œ ์„ ํƒ์ง€ ์ค‘ ํ•˜๋‚˜๋ฅผ ํƒํ•  ์ˆ˜ ์žˆ๋‹ค. Temporary Table(์ž„์‹œ ํ…Œ์ด๋ธ”) Derived Table Inline View ๋ณธ ๊ธ€์—์„œ๋Š” inline view๋ฅผ ์ด์šฉํ•˜์—ฌ Oracle WITH ๊ตฌ๋ฌธ์„ ๋ณ€๊ฒฝํ•ด ๋ณผ ๊ฒƒ์ด๋‹ค. WITH ๊ตฌ๋ฌธ์„ Inline View๋กœ ๋ณ€ํ™˜ํ•˜๋Š” ์˜ˆ์ œ ํŽธ์˜์ƒ ๊ฐ„๋‹จํ•œ ์ฟผ๋ฆฌ๋ฅผ ์˜ˆ์ œ๋กœ ๋“ค์—ˆ๋‹ค. โ„น๏ธOracle WITH: WITH SAMPLE_WITH AS (SELECT ID FROM SAMPLE_TBL) SELECT A.ID FROM ANOTHER_TBL A, SAMPLE_WITH B WHERE A.ID = B.ID โ„น๏ธMySQL Inlin.. 2020. 12. 8.
MySQL Workbench ์‚ฌ์šฉ ์ค‘ Error: DBMS connection is not available MySQL Workbench ์‚ฌ์šฉ ์ค‘ Error: DBMS connection is not available MySQL Workbench๋กœ DB์— ์—ฐ๊ฒฐํ•ด์„œ ์‚ฌ์šฉํ•˜๋‹ค๊ฐ€ ์ž ๊น ์ž‘์—…์„ ์•ˆํ•˜๊ณ ์žˆ์œผ๋ฉด ์—ฐ๊ฒฐ์ด ๋Š์–ด์งˆ๋•Œ๊ฐ€ ์žˆ๋‹ค. ์ด ์ƒํƒœ์—์„œ ์ฟผ๋ฆฌ๋ฅผ ๋‚ ๋ฆฌ๋ฉด Error: DBMS connection is not available ์—๋Ÿฌ๊ฐ€ ๋–จ์–ด์ง„๋‹ค. ์ด๋Ÿด ๋•Œ ํ™ˆ์œผ๋กœ ๋Œ์•„๊ฐ€์„œ ์ƒˆ๋กœ ์—ฐ๊ฒฐํ•˜๋Š” ๊ฒƒ ๋ณด๋‹ค๋Š”, MySQL Workbench > Query > Reconnect to Server๋กœ ์„œ๋ฒ„์™€ ์žฌ์—ฐ๊ฒฐํ•ด์„œ ์‚ฌ์šฉํ•˜๋ฉด ๋œ๋‹ค. ์ž‘์—…์ค‘์ด์—ˆ๋˜ sql์ด ๊ทธ๋Œ€๋กœ ์œ ์ง€๋˜๋‹ˆ ๋” ํŽธํ•˜๊ฒŒ ์ž‘์—…์„ ์ด์–ดํ•  ์ˆ˜ ์žˆ๋‹ค. 2020. 12. 7.
Oracle์˜ TO_CHAR ํ•จ์ˆ˜์™€ ๋Œ€์‘๋˜๋Š” MySQL ํ•จ์ˆ˜ Oracle TO_CHAR -> MySQL DATE_FORMAT Oracle์˜ TO_CHAR๋Š” MySQL์˜ DATE_FORMAT๊ณผ ๋Œ€์‘๋œ๋‹ค. โ„น๏ธ Oracle TO_CHAR ์‚ฌ์šฉ ์˜ˆ select TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') from dual 20201206153514 โ„น๏ธ MySQL DATE_FORMAT ์‚ฌ์šฉ ์˜ˆ select DATE_FORMAT(now(), '%Y%m%d%H%i%s') 20201206154329 Oracle TO_CHAR Syntax: TO_CHAR(์ˆซ์ž/๋‚ ์งœ, ํฌ๋งท) ์ˆซ์ž๋‚˜ ๋‚ ์งœ๋ฅผ ํŠน์ • ํฌ๋งท์˜ ๋ฌธ์ž๋กœ ๋ณ€ํ™˜ํ•˜๋Š” ํ•จ์ˆ˜ ์ฒซ ๋ฒˆ์งธ ๋งค๊ฐœ๋ณ€์ˆ˜๋กœ ์ˆซ์ž/๋‚ ์งœ๋ฅผ, ๋‘ ๋ฒˆ์งธ ๋งค๊ฐœ๋ณ€์ˆ˜๋กœ ํฌ๋งท์„ ์ง€์ •ํ•œ๋‹ค. TO_CHAR ๋‚ ์งœ ๋ณ€ํ™˜ ํฌ๋งท ํฌ๋งท ์„ค๋ช… ์‚ฌ์šฉ ์˜ˆ AM, A.M.. 2020. 12. 6.
H2 Database ์„ค์น˜, ์„œ๋ฒ„ ์‹คํ–‰, ์ ‘์† ๋ฐฉ๋ฒ• (Windows, MacOS) H2 Database ์„ค์น˜, ์„œ๋ฒ„ ์‹คํ–‰, ์ ‘์† ๋ฐฉ๋ฒ• (Windows, MacOS) H2 ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋Š” ์„ค์น˜๊ฐ€ ํ•„์š” ์—†๊ณ  ์šฉ๋Ÿ‰์ด ๋งค์šฐ ๊ฐ€๋ฒผ์šฐ๋ฉฐ ์›น์šฉ ์ฝ˜์†”(์ฟผ๋ฆฌํˆด)์„ ์ œ๊ณตํ•˜์—ฌ ๊ฐœ๋ฐœ์šฉ ๋กœ์ปฌ DB๋กœ ์‚ฌ์šฉํ•˜๊ธฐ ์ข‹์€ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์ด๋‹ค. H2์˜ ํŠน์ง•์„ ์ •๋ฆฌํ•˜๋ฉด ๋‹ค์Œ๊ณผ ๊ฐ™๋‹ค. Java๋กœ ์ž‘์„ฑ๋œ ์˜คํ”ˆ์†Œ์Šค RDBMS ์Šคํ”„๋ง ๋ถ€ํŠธ๊ฐ€ ์ง€์›ํ•˜๋Š” ์ธ๋ฉ”๋ชจ๋ฆฌ ๊ด€๊ณ„ํ˜• ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์ด๋‹ค. ์ธ๋ฉ”๋ชจ๋ฆฌ๋กœ ๋„์šฐ๋ฉด ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜์„ ์žฌ์‹œ์ž‘ํ•  ๋•Œ๋งˆ๋‹ค ์ดˆ๊ธฐํ™”๋œ๋‹ค. ๋ณ„๋„์˜ ์„ค์น˜๊ฐ€ ํ•„์š” ์—†๋‹ค. ๋กœ์ปฌ ํ™˜๊ฒฝ, ํ…Œ์ŠคํŠธ ํ™˜๊ฒฝ์—์„œ ๋งŽ์ด ์‚ฌ์šฉ๋œ๋‹ค. 1. H2 ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๋‹ค์šด๋กœ๋“œ http://h2database.com์— ๋“ค์–ด๊ฐ€์„œ All Platforms๋ฅผ ํด๋ฆญํ•œ๋‹ค. ์ฆ‰์‹œ ๋‹ค์šด๋กœ๋“œ๊ฐ€ ์‹œ์ž‘๋œ๋‹ค. ํ•ด๋‹น ๋งํฌ๋กœ ๋ฐ›์•„์ง€๋Š” ๋ฒ„์ „์€ 2020๋…„ 3์›” ๊ธฐ์ค€์œผ๋กœ 1.4.2 ๋ฒ„์ „์ด๋‹ค. 2.. 2020. 3. 18.
DB Connection Pool - ์šฉ์–ด ์ •๋ฆฌ์™€ Single Connection์˜ ๋ฌธ์ œ์  DB Connection Pool - ์šฉ์–ด ์ •๋ฆฌ์™€ Single Connection์˜ ๋ฌธ์ œ์  ์šฉ์–ด ์ •๋ฆฌ DB Connection Pool - DB ์ปค๋„ฅ์…˜์„ ๊ด€๋ฆฌํ•˜๋Š” ๊ฐ์ฒด - DB ์ปค๋„ฅ์…˜ ๊ฐ์ฒด๋ฅผ ์—ฌ๋Ÿฌ๊ฐœ ์ƒ์„ฑํ•ด์„œ Pool์— ๋‹ด์•„ ๋†“๊ณ  ํ•„์š”ํ• ๋•Œ ๊บผ๋‚ด ์“ฐ๋Š” ๋ฐฉ์‹ - ์‚ฌ์šฉ์ด ๋๋‚œ ๊ฐ์ฒด๋Š” ๋‹ค๋ฅธ ์ž‘์—…์—์„œ ๋‹ค์‹œ ์“ธ ์ˆ˜ ์žˆ๋„๋ก ํ’€์— ๋ฐ˜ํ™˜ Pooling ์ž์ฃผ ์“ฐ๋Š” ๊ฐ์ฒด๋ฅผ ๋ฏธ๋ฆฌ ๋งŒ๋“ค์–ด๋‘๊ณ , ํ•„์š”ํ• ๋•Œ๋งˆ๋‹ค ๋นŒ๋ฆฌ๊ณ , ์‚ฌ์šฉํ•œ ๋‹ค์Œ ๋ฐ˜๋‚ฉํ•˜๋Š” ๋ฐฉ์‹ Object Pool ์—ฌ๋Ÿฌ๊ฐœ์˜ ๊ฐ์ฒด๋ฅผ ๋ชจ์•„๋‘” ๊ฒƒ Single Connection์˜ ๋ฌธ์ œ์  ํ•˜๋‚˜์˜ Connection์—์„œ ์—ฌ๋Ÿฌ๊ฐœ์˜ Statement๋ฅผ ์ƒ์„ฑํ•ด์„œ ์‚ฌ์šฉํ•˜๋‹ค๊ฐ€ ํ•œ ๊ณณ์—์„œ ์˜ˆ์™ธ๊ฐ€ ๋ฐœ์ƒํ•˜๋ฉด rollback์„ ์ˆ˜ํ–‰ํ•ด์•ผ ํ•œ๋‹ค. Rollback์€ ์ปค๋„ฅ์…˜ ๊ฐ์ฒด๋ฅผ ํ†ตํ•ด์„œ๋งŒ ์ˆ˜ํ–‰ํ•  ์ˆ˜ ์žˆ๋‹ค. ๋ฌธ์ œ.. 2020. 2. 16.
Windows MySQL my.ini ํŒŒ์ผ ์œ„์น˜ - MSI Installer๋กœ ์„ค์น˜ํ•œ ๊ฒฝ์šฐ Windows MySQL my.ini ํŒŒ์ผ ์œ„์น˜ - MSI Installer๋กœ ์„ค์น˜ํ•œ ๊ฒฝ์šฐ MySQL my.ini ํŒŒ์ผ์€ ๋ณดํ†ต MySQL basedir ํ•˜์œ„์— ์žˆ๋‹ค. basedir์€ ์•„๋ž˜์™€ ๊ฐ™์ด ํ™•์ธ์ด ๊ฐ€๋Šฅํ•˜๋‹ค. SHOW VARIABLES WHERE Variable_Name LIKE "%dir"; ๊ทธ๋Ÿฌ๋‚˜ ์œˆ๋„์šฐ ํ”Œ๋žซํผ์— .msi ์ธ์Šคํ†จ๋Ÿฌ๋กœ ์„ค์น˜ํ•œ ๊ฒฝ์šฐ my.ini ํŒŒ์ผ์€ MySQL basedir ํ•˜์œ„๊ฐ€ ์•„๋‹ˆ๋ผ %PROGRAMDATA% ๋””๋ ‰ํ† ๋ฆฌ ํ•˜์œ„์— ๋งŒ๋“ค์–ด์ง„๋‹ค. ์šฐ์„  ์œˆ๋„์šฐ ์ปค๋งจ๋“œ์ฐฝ์„ ๋„์›Œ %PROGRAMDATA% ๋””๋ ‰ํ† ๋ฆฌ๋ฅผ ํ™•์ธํ•œ๋‹ค. echo %PROGRAMDATA%๋ฅผ ์ž…๋ ฅํ•˜๋ฉด ํ™•์ธํ•  ์ˆ˜ ์žˆ๋‹ค. ๋ณดํ†ต ์œ„์™€ ๊ฐ™์ด C:\ProgramData์ด๋‹ค. ํƒ์ƒ‰๊ธฐ๋ฅผ ๋„์›Œ ์ถœ๋ ฅ๋œ ๋””๋ ‰ํ† ๋ฆฌ๋กœ ์ด๋™ํ•œ๋‹ค. MySQL ๋””๋ ‰ํ† .. 2020. 2. 9.
[MySQL] The server time zone value is unrecognized or represents more than one time zone ์—๋Ÿฌ ํ•ด๊ฒฐ ๋ฐฉ๋ฒ• The server time zone value is unrecognized or represents more than one time zone ์—๋Ÿฌ ํ•ด๊ฒฐ ๋ฐฉ๋ฒ• Java์—์„œ ๋กœ์ปฌ MySQL ์„œ๋ฒ„์— ์—ฐ๊ฒฐํ•˜๋˜ ์ค‘ ์•„๋ž˜์™€ ๊ฐ™์€ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ–ˆ๋‹ค. java.sql.SQLException: The server time zone value is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utiliz.. 2020. 2. 9.
[Oracle] ORA-01555 Snapshot too old ์—๋Ÿฌ ์›์ธ๊ณผ ํ•ด๊ฒฐ ๋ฐฉ๋ฒ• [Oracle] ORA-01555 Snapshot too old ์—๋Ÿฌ ์›์ธ๊ณผ ํ•ด๊ฒฐ ๋ฐฉ๋ฒ• ์˜ค๋ผํด ORA-01555 ์—๋Ÿฌ ORA-01555: ๋„ˆ๋ฌด ์ด์ „ ์Šค๋ƒ…์ƒท:๋กค๋ฐฑ ์„ธ๊ทธ๋จผํŠธ %s ์ˆ˜์— "%s" ์ด๋ฆ„์œผ๋กœ ๋œ ๊ฒƒ์ด ๋„ˆ๋ฌด ์ž‘์Šต๋‹ˆ๋‹ค ORA-01555: snapshot too old:rollback segment number %s with name "%s" too small ์œ„์™€ ๊ฐ™์ด ๋ฉ”์‹œ์ง€๊ฐ€ ์ถœ๋ ฅ๋˜๋ฉฐ ORA-01555๋Š” ๋ฐ์ดํ„ฐ ํ›ผ์†์ด๋‚˜ ๋ฐ์ดํ„ฐ ์†์‹ค๊ณผ๋Š” ์•„๋ฌด ๊ด€๋ จ์ด ์—†์Šต๋‹ˆ๋‹ค. ๊ทธ๋Ÿฐ ์ ์—์„œ ์•ˆ์ „ํ•œ ์˜ค๋ฅ˜์ด๊ณ , ๋‹จ์ง€ ์ด ์˜ค๋ฅ˜๋ฅผ ๋งŒ๋‚˜๋Š” ์ˆœ๊ฐ„ ์ฟผ๋ฆฌ๋ฅผ ๊ณ„์† ์ง„ํ–‰ํ•  ์ˆ˜ ์—†์Šต๋‹ˆ๋‹ค. ์ตœ๊ทผ ์ด ์—๋Ÿฌ๋ฅผ ๋งž๋‹ฅ๋œจ๋ฆฌ๊ฒŒ ๋˜์–ด ์›์ธ ๋ฐ ํ•ด๊ฒฐ๋ฐฉ๋ฒ•์„ ๊ณต์œ ํ•˜๊ณ ์ž ํ•ฉ๋‹ˆ๋‹ค. ์—๋Ÿฌ ๋ฐœ์ƒ ์‹œ๋‚˜๋ฆฌ์˜ค ๋จผ์ € ORA-01555๊ฐ€ ๋ฐœ์ƒํ•  ์ˆ˜ ์žˆ๋Š” ์‹œ๋‚˜๋ฆฌ์˜ค์˜ ์˜ˆ๋ฅผ ํƒ€.. 2017. 11. 30.