我是菜鸟。 PCTFREE integer Specify the percentage of space in each data block of the table, object table OID index, or partition reserved for future updates to the table's rows. The value of PCTFREE must be a value from 0 to 99. A value of 0 means that the entire block can be filled by inserts of new rows. The default value is 10. This value reserves 10% of each block for updates to existing rows and allows inserts of new rows to fill a maximum of 90% of each block. 指定表的每个数据块的空间百分比,对象表OID索引,或者为将来表的行的更新保留的分区。
可以用select table_name, pct_free from user_tables ;查看
能不能告知pctfree的解释阿,谢谢 :)
PCTFREE integer
Specify the percentage of space in each data block of the table, object table OID index, or partition reserved for future updates to the table's rows. The value of PCTFREE must be a value from 0 to 99. A value of 0 means that the entire block can be filled by inserts of new rows. The default value is 10. This value reserves 10% of each block for updates to existing rows and allows inserts of new rows to fill a maximum of 90% of each block. 指定表的每个数据块的空间百分比,对象表OID索引,或者为将来表的行的更新保留的分区。