This discussion is archived
1 Reply Latest reply: Jan 21, 2013 6:28 AM by riedelme RSS

sqlldr bindsize parameter

652398 Newbie
Currently Being Moderated
Using sqlldr to import data:
sqlldr ${user_id} control=${ctl_file} rows=10000 bindsize=8192 readsize=8192 errors=999999 log=${log_file}/${today_DATE}.log

When executing:
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
...

In data file, there is only 80 characters(that is 80 bytes) in every row. However, in log file:
Space allocated for bind array: 6714 bytes(2 rows)

Why 6714 bytes is here? Except the 160 bytes for two rows, what's the other sizes?

Thanks a lot for your kindly reply.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points