sqlldr的commit问题
使用如下内容执行一个sqlldr操作向数据库表插数:
sqlldr ${user_id} control=${ctl_file} rows=10000 bindsize=8192 readsize=8192 errors=999999 log=${log_file}/${today_DATE}.log
但执行时,看到以下内容:
Commit point reached - logical record count 2
Commit point reached - logical record count 4
Commit point reached - logical record count 6
Commit point reached - logical record count 8
Commit point reached - logical record count 10
Commit point reached - logical record count 12
...
请问:
1、我这里没有设置direct=true,应该还是传统的导入方式,那rows定义为10000,为什么显示2行Commit一次呢?
2、如果这里是传统的导入方式,rows=10000是否应该表示10000行执行一次commit操作呢?
谢谢!