RE: sqlloader tuning
1. Review this article by Stephen Andert: http://oracle.oreilly.com/news/oraclesqlload_0401.html 2. No. - Kirti - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 9:08 AM 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
RE: sqlloader tuning
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=2 bindsize=500 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: 500 Adjust accordingly - bindsize = 2*(4999560/10245) = 976 sqlldr rows=2 bindsize=976 load=1 log=load.log Space allocated for bind array:976 bytes(2 rows) Read buffer bytes: 976 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth 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).
RE: sqlloader tuning
Hi, Beth and Kirti thank you so much for your clarification. cheers, ravi --- Deshpande, Kirti [EMAIL PROTECTED] wrote: 1. Review this article by Stephen Andert: http://oracle.oreilly.com/news/oraclesqlload_0401.html 2. No. - Kirti - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 9:08 AM 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). __ 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: [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).