|
|
[ÀϹÝ] [¿À¶óŬƩ´×] shared_pool_size sga ¿µ¿ªÀÇ ¼öÁ¤ |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 211.¢½.74.31 |
ÀÐÀ½:5159 |
|
|
alter system set db_cache_size = 250M ;
À§ sql ¹® ½ÇÇàÇÏ¸é ¾Æ·¡¿Í °°Àº ¿¡·¯°¡ ³³´Ï´Ù.
ORA-02097: ÁöÁ¤µÈ °ªÀÌ ºÎÀû´çÇؼ ¸Å°³º¯¼ö¸¦ ¼öÁ¤ÇÒ ¼ö ¾ø½À´Ï´Ù
ORA-00384: ij½Ã¸¦ ´Ã¸®±â À§ÇÑ ¸Þ¸ð¸® ºÎÁ·
´äº¯ ºÎŹµå¸³´Ï´Ù.
ÀÌ ±Û¿¡ ´ëÇÑ ´ñ±ÛÀÌ ÃÑ 4°Ç ÀÖ½À´Ï´Ù.parameter ¿¡¼ sga_max_size ¸¦ È®ÀÎÇغ¸¼¼¿ä...
shared pool °ú db_cache_size ÀÇ ÇÕÀÌ sga_max_size °ªÀ»
³Ñ¾î ¼³¼ö ¾ø½À´Ï´Ù.
¼ö°íÇϼ¼¿ä.
³ª±×³×´ÔÀÌ 2004-12-21 12:00:42¿¡ ÀÛ¼ºÇÑ ´ñ±ÛÀÔ´Ï´Ù. Edit £Ø³ª±×³×´Ô
´äº¯ °¨»çµå¸³´Ï´Ù.
±×·¯¸é sga_max_size¸¦ º¯°æÇÒ·Á¸é
¾î¶»°Ô ÇØ¾ß Çϳª¿ä
ÇöÀç sga_max_size = 129MÀÌ°í
shared_pool_size = 48M
db_cache_size = 24MÀÔ´Ï´Ù.
µû¶ó¼ shared_pool_size = 200M
db_cache_size=250M·Î º¯°æÇÒ·Á°í Çϴµ¥
À§ ¿¡·¯°¡ ¹ß»ýÀ» ÇÞ´ø°Å±¸¿ä
±×·±µ¥ alter system set sga_max_size = 500M ;
Çß´õ´Ï ORA-02095: ÁöÁ¤µÈ ÃʱâÈ ¸Å°³º¯¼ö¸¦ ¼öÁ¤ÇÒ ¼ö ¾ø½À´Ï´Ù
¿¡·¯°¡ ³ª³×¿ä.
sga_max_size´Â ¼öÁ¤ÇÒ¼ö ¾ø´Â°ÍÀΰ¡¿ä?
Áñ°Å¿î ÇÏ·ç µÇ¼¼¿ä^^
±Þ±×´ÔÀÌ 2004-12-21 12:52:09¿¡ ÀÛ¼ºÇÑ ´ñ±ÛÀÔ´Ï´Ù.
ÀÌ ´ñ±ÛÀº 2004-12-21 12:59:31¿¡ ¸¶Áö¸·À¸·Î ¼öÁ¤µÇ¾ú½À´Ï´Ù. Edit £Ø¿À¶óŬ 9 ¹öÀü¿¡¼ ÆĶó¹ÌÅ͸¦ µ¿ÀûÀ¸·Î °ü¸® ÇÒ¼ö ÀÖ´Â ºÎºÐ°ú
°ü¸® ÇÏÁö ¸øÇÏ´Â ºÎºÐÀÌ ÀÖ½À´Ï´Ù.
sga_max_size ´Â static ÆĶó¹ÌÅÍ À̹ǷΠ¾Æ·¡¿Í °°ÀÌ spfile ¿¡¼
¼öÁ¤ÈÄ µ¥ÀÌÅÍ º£À̽º¸¦ ´Ù½Ã restartup ÇØ¾ß ÇÕ´Ï´Ù.
alter system set sga_max_size = 500000000 scope = spfile;
ÀÌ·¸°Ô ¼öÁ¤ÈÄ ¾Æ·¡¿Í °°ÀÌ restartup ÇØÁÖ¼¼¿ä..
sql>shutdown immediate
sql> startup
ÇÏ½Ã¸é µË´Ï´Ù. ¼ö°íÇϼ¼¿ä
³ª±×³×´ÔÀÌ 2004-12-21 13:17:04¿¡ ÀÛ¼ºÇÑ ´ñ±ÛÀÔ´Ï´Ù. Edit £Ø°¨»çÇÕ´Ï´Ù. ³ª±×³×´Ô
´öºÐ¿¡ ¸¹Àº°É ¹è¿ü½À´Ï´Ù.
¼ö°íÇϼ¼¿ä^^
±Þ±Þ´ÔÀÌ 2004-12-21 13:46:41¿¡ ÀÛ¼ºÇÑ ´ñ±ÛÀÔ´Ï´Ù. Edit £Ø
[Top]No. Á¦¸ñ ÀÛ¼ºÀÚ ÀÛ¼ºÀÏ Á¶È¸
21138 ±×·ìº°·Î ¼ø¼°¡ °¡ÀåÀÛÀº ÇàÀ» ±¸ÇÏ´Â QueryÁ» ºÎŹÇÕ´Ï´Ù. [1] ¹ÚÈ«±Ô 2004-12-21 211
21137 UNION Çؼ µÎÅ×À̺íÀ» Á¶È¸ ÈÄ °°Àº¼±»ó¿¡ »Ñ·ÁÁִ¹ýÁ» ºÎŹ.. [6] °½Â¿ì 2004-12-21 616
21136 ÀμƮ½Ã Áú¹®ÀÔ´Ï´Ù. [1] ¿À¶ó 2004-12-21 220
21135 ora-02097, ora-00384 ¿¡·¯ (±Þ) [4] ±Þ±Þ 2004-12-21 375
21134 ¸±·¹À̼ÇÀº ÇʼöÀûÀÎ °ÍÀΰ¡¿ä? ÇѸð¸ð 2004-12-21 197
21133 jdbcµå¶óÀ̹ö ¹®Á¦ÀΰŠ°°Àºµ¥¿ä.. [4] ±è¸íÀç 2004-12-21 679
21132 ROW°ªÀ» Å×ÀÌºí¿¡ ³ÖÀ»¼ö ÀÖ´Â ¹æ¹ý Á».. ¹Ì·ÉÀÌ 2004-12-21 225
|
|
|
|
|
|