๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
ORACLE/ADMIN

[ORACLE] Reserved Pool ์—ญํ•  ๋ฐ ํ™•์ธ

by ๐ŸŒปโ™š 2020. 7. 5.

Reserved Pool

Oracle Reserved Pool์€ Shared Pool์— ํฌ๊ธฐ๊ฐ€ ํฐ ์˜ค๋ธŒ์ ํŠธ๋ฅผ ์ €์žฅํ•ด์•ผํ•˜๋Š” ๊ฒฝ์šฐ ์‚ฌ์šฉ๋˜๋Š” ๋ฉ”๋ชจ๋ฆฌ์ž…๋‹ˆ๋‹ค. Parsing๋œ SQL์ด๋‚˜ PL/SQL ๋ฌธ์žฅ ๋ฐ ์‹คํ–‰๊ณ„ํš๋“ค์€ Library Cache์— ์ €์žฅ์„ ํ•ฉ๋‹ˆ๋‹ค. ๊ทธ๋Ÿฐ๋ฐ ์ด๋•Œ ๋‚ด๋ถ€์ ์œผ๋กœ Chunk๋ผ๋Š” 1KB or 4KB ํฌ๊ธฐ์˜ ์กฐ๊ฐ์œผ๋กœ ์˜ค๋ธŒ์ ํŠธ๋ฅผ ์ €์žฅํ•˜๋Š”๋ฐ ๋งŒ์•ฝ ์ด๋ณด๋‹ค ํฐ ํฌ๊ธฐ์˜ Chunk๋ฅผ ์‚ฌ์šฉํ•ด์•ผํ•˜๋Š” ๊ฒฝ์šฐ์— Reserved Pool์„ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค.

 

Reserved Pool ์šฉ๋Ÿ‰ ํ™•์ธ

SHOW PARAMETER SHARED_POOL_RESERVED_SIZE

 

Reserved Pool ์ •๋ฆฌ

- Parsed๋œ ํฌ๊ธฐ๊ฐ€ ํฐ SQL or PL/SQL ์˜ค๋ธŒ์ ํŠธ๋ฅผ ์ €์žฅํ•˜๋Š” ๊ณต๊ฐ„

 

๋Œ“๊ธ€