Oracle的Automatic Segment Space Management (ASSM)自动管理数据块的使用，根据行占用空间将块分为四个满度类别。插入操作会尝试找到适合新行长度的空闲空间，而更新操作则会尽力在已有空间内适应新行大小。ASSM的默认PCTFREE不针对所有压缩方法设置为10%，并且不是所有情况下都能确保短行的插入资格。
23、Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)
A. PCTFREE defaults to 10% for all blocks in all segments for all compression methods
B. ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows
C. Update operations always attempt to find blocks with free space appropriate to the length of the row being updated
D. Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted
E. A block will always be eligible for inserts if the row is short enough to fit into the block
source : cuug
2008
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
