1 Reply Latest reply: Jan 21, 2013 8:28 AM by riedelme RSS

    sqlldr bindsize parameter

    652398
      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.