SQL Loader / Multithreading option not working?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: SQL Loader / Multithreading option not working?

Threaded View

  1. #1
    Join Date
    Feb 2010
    Posts
    3

    SQL Loader / Multithreading option not working?

    Hello,

    I'm trying to speed up some loads on some rather large flat files that are produced off a mainframe and sent down to a unix box for loading.

    These machines are typically AIX boxes with SMT turned on. Oracle Version is 10g.

    All these loads are using direct path / with truncate option and we are seeing ~36 hours to load one file that is approximately 260 gigs in size. (This data file is fixed width)

    Since these machines are running ~16 CPU's I wanted to test SQL loader with the multithreading=true option.

    I'm invoking these loads from a script:

    sqlldr / control=${CNAME} errors=0 bad=${BADNAME} log=${LOG}_load data=${DATAFILE} direct=true rows=5000 streamsize=1048576 readsize=1048576 columnarrayrows=8000 multithreading=true

    I ran a couple tests (on some much smaller files) but I'm still getting logs that look like:


    Total stream buffers loaded by SQL*Loader main thread: 2245
    Total stream buffers loaded by SQL*Loader load thread: 0

    Why is nothing showing being loaded into the load thread? Is there some option in ora.init / something I am missing here?

    In addition to this I am also looking at trying Parallel Direct Path w/ one or multiple files.

    Any help is appreciated!

    -Kevin
    Last edited by chistik; 02-22-2010 at 03:42 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width