监视rebalance[@more@]

监视rebalance

可以通过获得表空间的快照来查看rebalance的过程，这个功能是在v8之后被增强了。

可以通过这个snapshot来查看：

1、rebalance的模式：向前还是向后

2、rebanlace开始的时间

3、有多少扩展被处理了，还有多少没有被处理

4、表空间的映射

Number of usable pages = 6000

Number of used pages = 3000

Number of pending free pages = 0

Number of free pages = 0

High water mark (pages) = 3000

Rebalancer Mode = Forward

Start Time = 03-06-2002 11:55:39.000000

Restart Time = 03-06-2002 12:16:14.000000

Number of extents processed = 137

Number of extents remaining = 163

Last extent moved = 137

Table space map:

Range Stripe Stripe Max Max Start End Adj. Containers

Number Set Offset Extent Page Stripe Stripe

[ 0] [ 0] 0 136 1369 0 22 0 6(0,1,2,3,4,5)

[ 1] [ 0] 0 137 1379 45 45 0 1 (2)

[ 2] [ 0] 0 299 2999 46 99 0 3 (0,1,2)

ITPub博客