๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
[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.