๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

library cache1

[ORACLE] Library cache ์—ญํ•  ๋ฐ ํ™•์ธ Oracle Library Cache Library Cache๋Š” Oracle Instance SGA Shared Pool ์˜์—ญ์— ์กด์žฌํ•œ๋‹ค. ์กด์žฌ์˜ ๊ถ๊ทน์ ์ธ ๋ชฉํ‘œ๋Š” Oracle์˜ ์„ฑ๋Šฅ์„ ๋†’์—ฌ์ฃผ๊ธฐ ์œ„ํ•จ์ด๋‹ค. ์‚ฌ์šฉ์ž๊ฐ€ SQL ๋ฌธ์žฅ์„ ์งˆ์˜ ํ–ˆ์„๋•Œ Oracle ๋‚ด๋ถ€์—์„œ๋Š” Parse - Execute - Fetch ๋‹จ๊ณ„๋ฅผ ์ง„ํ–‰ํ•˜์—ฌ ๊ฒฐ๊ณผ๋ฅผ ๋ฐ˜ํ™˜ํ•ด์ฃผ๋Š”๋ฐ Library Cache์— ์ €์žฅ๋˜์–ด ์žˆ๋Š” ์ •๋ณด์— ๋”ฐ๋ผ Parse ๋‹จ๊ณ„๋ฅผ ๊ฑฐ์น˜์ง€ ์•Š๊ณ  ๋ฉ”๋ชจ๋ฆฌ์— ์ €์žฅ๋œ ์ •๋ณด๋ฅผ ๊ทธ๋Œ€๋กœ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๋‹ค. Library Cache ๋‚ด๋ถ€์—๋Š” ๊ณต์œ  SQL ์˜์—ญ(Shared SQL Area)๊ณผ ๊ณต์œ  PL/SQL ์˜์—ญ(Shared PL/SQL Area)์ด ์กด์žฌํ•˜๋Š”๋ฐ, ํŒŒ์Šค ๊ณผ์ •์ด ์™„๋ฃŒ๋˜๋ฉด ์‚ฌ์šฉ์ž๊ฐ€ ์‹คํ–‰ํ•œ SQL ๋ฌธ์žฅ๊ณผ ์‹คํ–‰๊ณ„ํš์ด ์ €์žฅ๋˜๋Š” ๊ณต๊ฐ„์ด๋‹ค... 2020. 7. 5.

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”