As per my observation, when we load the data to Oracle tables using SQL* Loader, 64 records are committed at once, by default.
Could you please let me know if we can change this default limit of insertion/commit to number other than 64?
Also, can we avoid the display of loading, shown below on the console?
Commit point reached - logical record count 64
Commit point reached - logical record count 128
Commit point reached - logical record count 192
From the reference:
rows
-- number of rows in conventional path bind array or between direct path data saves
(Default: Conventional path 64, Direct path all)
So you'd specify rows=1024
or whatever on the command line or parameter file.
As for avoiding the display, I don't think there's an option to suppress only the progress information. There is silent
but that might be more than you want. Filter those out with grep
if you don't want to see them.