| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: sqlloader question
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:jonathan_at_gennick.com * 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: jonathan_at_gennick.com
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). Received on Tue Jul 03 2001 - 14:03:10 CDT
 |
 |