Oracle-L: RE: sqlloader tuning

From: Seefelt, Beth <Beth.Seefelt_at_TetleyUSA.com>
Date: Wed, 26 Jun 2002 08:28:39 -0800
Message-ID: <F001.00488BCE.20020626082839@fatcity.com>

Ravi,

You can't use sql functions in the control file with direct=true. You can do a direct load, and then run a sql script on the loaded data to make changes. Sometimes the performance gains from the direct load make that worthwhile.

Set bindsize=rows*rowlength where rows is the number of rows you want to load before each commit, rowlength is the length of the records in the flat file.

To see if you selected appropriate values, run a load of 1 record and generate a log file -

sqlldr rows=20000 bindsize=5000000 load=1 log=load.log

Check the log to see if you sized appropriately

Space allocated for bind array:                4999560 bytes(10245 rows)

Read buffer bytes: 5000000

Adjust accordingly - bindsize = 20000*(4999560/10245) = 9760000

sqlldr rows=20000 bindsize=9760000 load=1 log=load.log

Space allocated for bind array:                9760000 bytes(20000 rows)

Read buffer bytes: 9760000

HTH, Beth

-----Original Message-----
Sent: Wednesday, June 26, 2002 10:09 AM
To: Multiple recipients of list ORACLE-L

Hi all,

Can any one please tell me what is the deciding factor to specify rows value and bindsize value in sqlloader option?

is there any option to use direct=true while using function in control file?

DB:8.1.7 os:SUN SS
thanks for your help.

Cheers,
Ravi

Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: =?iso-8859-1?q?Nalla=20Ravi?=
INET: vvnrk2001_at_yahoo.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Seefelt, Beth
INET: Beth.Seefelt_at_TetleyUSA.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------