『[Oracle] UNDOè¡¨é ˜åŸŸã®å¿…è¦å®¹é‡è¦‹ç©ã‚‚り方法ã€UNDOè¡¨é ˜åŸŸã«å¿…è¦ãªå®¹é‡ã¯ä»¥ä¸‹ã®å…¬å¼ã§è¦‹ç©ã‚‚ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ UNDOè¡¨é ˜åŸŸå¿…è¦å®¹é‡(byte) = UNDOä¿å˜æœŸé–“(秒) × 1秒ã‚ãŸã‚ŠUNDOブãƒãƒƒã‚¯ç”Ÿæˆæ•° × ブãƒãƒƒã‚¯ã‚µã‚¤ã‚º ＋ オーãƒãƒ¼ãƒ˜ãƒƒãƒ‰(byte) 例ãˆã°ã€UNDOä¿å˜æœŸé–“ãŒ900秒ã§ã€1秒ã‚ãŸã‚Šã®UNDOブãƒãƒƒã‚¯ç”Ÿæˆæ•°ãŒ100ã§ã€ãƒ–ãƒãƒƒã‚¯ã‚µã‚¤ã‚ºãŒ8192ãƒã‚¤ãƒˆã®å ´åˆã€ 900×100×8192ï¼737280000 ã¤ã¾ã‚Šç´„703MB＋オーãƒãƒ¼ãƒ˜ãƒƒãƒ‰ã¨ã„ã†ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ ã“ã®è¨ˆç®—ã«å¿…è¦ãªæƒ…å ±ã¯V$UNDOSTATã¾ãŸã¯DBA_HIST_UNDOSTATã‹ã‚‰å¾—ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã“れらã®ãƒ“ューã«ã¯UNDOçµ±è¨ˆæƒ…å ±ãŒ10分ã”ã¨ã«è¨˜éŒ²ã•ã‚Œã¦ã„ã¾ã™ã€‚ SQL> SELECT TO_CHAR(BEGIN_TIME,'MM/DD HH24:MI') AS BEGIN_TIME, TO_CHAR(END_TIME, 'MM/DD
![『[Oracle] UNDOè¡¨é ˜åŸŸã®å¿…è¦å®¹é‡è¦‹ç©ã‚‚り方法ã€](https://cdn-ak-scissors.b.st-hatena.com/image/square/ed239427f781d723ae5cf65616a522073f68d378/height=288;version=1;width=512/https%3A%2F%2Fstat.profile.ameba.jp%2Fprofile_images%2F31%2Farchive-redo-blog%2F1180840362506.jpg)
dfltweb1.onamae.com – ã“ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ã¯ãŠåå‰.comã§å–å¾—ã•ã‚Œã¦ã„ã¾ã™ã€‚
http://www-1.ibm.com/support/docview.wss?uid=std3ff404ad9e7a7301a49256dc70052b2d1
PC
{{#tags}}- {{label}}
{{/tags}}