SQL *Loader中 Commit point 的疑问
SQL *Loader什么时候commit 一次数据呢?下面是我节选的一段输出报告,好像SQL *Loader不是按照一个固定的记录数来commit的。
Commit point reached - logical record count 44725
Commit point reached - logical record count 44741
Commit point reached - logical record count 44757
Commit point reached - logical record count 44773
Commit point reached - logical record count 44789
Commit point reached - logical record count 44805
Commit point reached - logical record count 44821
Commit point reached - logical record count 44837
Commit point reached - logical record count 44853
Commit point reached - logical record count 44869
现在sql loader缺省好像差不多16条记录 commit 一次,为了提高导数据的效率,有什么办法可以设置一下?