ROWS takes on a slightly different semantic meaning
depending on whether your load is direct-path or
conventional, but the practical effect is pretty much the
same. For a conventional path load, ROWS specifies the
number of rows for the bind array, which ends up being the
number of rows loaded between commits. For a direct-path
load, ROWS specifies the number of rows to read from the
input file before saving them to the database. The semantics
of commit don't apply to direct-path load: for example, triggers don't
fire. Specifying ROWS in conjunction with DIRECT will NOT
cause your load to use the conventional path. Saving at the
end of a direct-path load (the default) is best
performance-wise, but the tradeoff is that if the load
fails, you get to do it ALL over again. Specifying a value
for ROWS puts a limit on the amount of the load that you
will need to redo in the event of a failure. It's all a
tradeoff.
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org
Tuesday, July 03, 2001, 1:02:25 PM, you wrote:
lcc> Hello oradba's,
lcc> I have a general question about sqlloader.
lcc> There is an option called ROWS. According to Oracle Complete reference by
lcc> G.Koch and K.Loney ROWS is the number of rows to buffer together for an
lcc> insert and commit. Default value is 64.
lcc> According to one of my coworkers specifying ROWS in combination with
lcc> LOAD=DIRECT is not a good idea. Supposedly it will confuse and slow down
lcc> the load, possibly throw it to a non-direct load. The theory is based on
lcc> the following idea: during direct load sql loader is not supposed to count
lcc> and commit records.
lcc> Does it sound like true?
lcc> Lyuda Hoska
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Gennick
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
