±Û¾´ÀÌ :Á¶¹Î¼ö 2000³â 1¿ù 24ÀÏ 11:16:25
In Reply to: [Áú¹®]oracle¿¡¼ insert°¡ posted by ÇØ¿î on 1999³â 11¿ù 29ÀÏ 18:00:36:
SYSTEM rollback segment´Â dictionaryÁ¤º¸µîÀ» °»½ÅÇÒ ¶§¿¡¸¸ »ç¿ëÇÏ´Â rollback segmentÀÔ´Ï´Ù. ÀÏ¹Ý user°¡ À̸¦ »ç¿ëÇÑ´Ù¸é system tablespace°¡ SYSTEM rollback segment¶§¹®¿¡ fragmentationµµ ¸¹ÀÌ ¹ß»ýÇÏ´Â µî ¹®Á¦°¡ ¸¹°ÚÁö¿ä. µû¶ó¼ rollback segment¸¦ system tablespace°¡ ¾Æ´Ñ °÷¿¡ ¸¸µé¾î Áֽʽÿä. º¸ÅëÀº database¸¦ ¸¸µé½Ã¿¡ r01,r02,r03,r04¸¦ ¸¸µé¾î Áִµ¥ Àú·± ¿¡¶ó°¡ ³ª´Â °ÍÀº ¾Æ¸¶µµ r01-04¸ðµÎ offlineµÇ¾î ÀÖÀ» ¼öµµ Àֳ׿ä...