INSERT是否有物理读

zergduan

还有一种情况
INSERT slow on ASSM (文档 ID 1263496.1)

Yong Huang

> 还有一种情况
> INSERT slow on ASSM (文档 ID 1263496.1)

The note suggests a workaround

"The workaround is to manually mark these blocks as full or to increase the PCTFREE to a higher value in order to promote blocks to be marked as full in a better rate.

To mark a block as full use:
EXECUTE DBMS_REPAIR.SEGMENT_FIX_STATUS('<owner>','<table_name>');"

I wonder if the syntax is missing status_value=>1, because without explicitly setting block status to 1 (i.e. full), the default is null, meaning "the status will be set based on the current state of the block". But isn't the current state of the block not completely full? Isn't the whole purpose of running this procedure to manually set the status to full?