| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> sqlloader question
Hello oradba's,
I have a general question about sqlloader.
There is an option called ROWS. According to Oracle Complete reference by
G.Koch and K.Loney ROWS is the number of rows to buffer together for an
insert and commit. Default value is 64.
According to one of my coworkers specifying ROWS in combination with
LOAD=DIRECT is not a good idea. Supposedly it will confuse and slow down
the load, possibly throw it to a non-direct load. The theory is based on
the following idea: during direct load sql loader is not supposed to count
and commit records.
Does it sound like true?
Lyuda Hoska
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: lhoska_at_calibresys.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 - 10:49:42 CDT
 |
 |