SQLLDR直接加载能否分批提交?

viadeazhu

其实OCP的PPT讲得还比较清晰：
The following features differentiate a data save from COMMIT:
During a data save, only full database blocks are written to the database.
The blocks are written after the high-water mark (HWM) of the table.
After a data save, the high-water mark (HWM) is moved.
Internal resources are not released after a data save.
A data save does not end the transaction.
Indexes are not updated at each data save.

data save就是hwm的移动过程。
data save并不终结一个transaction，所以即使你看到了hwm的增长，数据也不可见，因为这个sqlldr的事务还没完成。这应该是在这些hwm下的数据有个标志位表明此事务还正active。

想你的懒猪

good