在IBM的网站上找到了问题的原因,卖弄一下吧。
Technote (FAQ)
Question
What means messages like this in online.log ?
00:31:45 Physical Logging during partition extend: Number of bit map pages to be logged in critcal section: 51 Remaining Phyical Log: 1762220
Cause
Load data into tables
Answer
We have a situation where we are allocating a large extent. The large extent allocates many bitmap pages. All these have to be physically logged and when we do that we are in a critical section. If we are in a critical section, check points have to wait. In that case, we just make sure we have enough physical log. In this case, there is plenty of physical log.
A critical section is just a transaction that does INSERT/UPDATE/DELETE or does explicit or implicit DDL grabbing extra extents. To extend a partition(read table) is one of those implicit ddl's.
如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!
赞0
添加新评论0 条评论