SQL*Loader version (Client) : 12.2
OS : Oracle Linux 6.9
DB version: 11.2.0.4
I am loading IDs in flat file /data1/loadext/ISDNs.dat into a single column table (temp_ids). The load worked fine.
But, the commit frequency doesn't seem to work as I expected.
Despite setting the commit frequency at 50,000 using ROWS parameter, the log output seem to show that the commit happens every 992 rows
--- Control file
OPTIONS
(
ROWS=50000
)
load data
infile '/data1/loadext/ISDNs.dat'
into table temp_ids
fields terminated by "," (isdn)
-- Log
$ sqlldr scott/tiger@10.80.71.215:1521/MSHPRD control=/data1/loadext/loader.ctl
SQL*Loader: Release 12.2.0.1.0 - Production on Thu Mar 22 18:15:53 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Path used: Conventional
Commit point reached - logical record count 992
Commit point reached - logical record count 1984
Commit point reached - logical record count 2976
Commit point reached - logical record count 3968
Commit point reached - logical record count 4960
Commit point reached - logical record count 5952
Commit point reached - logical record count 6944
Commit point reached - logical record count 7936
Commit point reached - logical record count 8928
Commit point reached - logical record count 9920
Commit point reached - logical record count 10912
Commit point reached - logical record count 11904
Commit point reached - logical record count 12896
Commit point reached - logical record count 13888
Commit point reached - logical record count 14880
.
.
<output snipped for readability>
.
.
Commit point reached - logical record count 1378570
Table TEMP_IDS:
1378570 Rows successfully loaded.
Check the log file:
loader.log
for more information about the load.