I knew, it'll come down to this: run_sql_faster = true :-)
Igor Neyman, OCP DBA [EMAIL PROTECTED] ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, August 13, 2002 4:34 PM > Is there a parameter that I can tune in init.ora file to improve this > process? > > Thanks, > David > > -----Original Message----- > Sent: Tuesday, August 13, 2002 2:00 PM > To: Multiple recipients of list ORACLE-L > > > Bind variables will not buy you anything. The time taken is mainly dependent > on the execution plan and the cardinality of the indexes being used. Also > any overhead like updating a column that's part of an index, triggers, > referential constraints, etc. > > Waleed > > -----Original Message----- > Sent: Tuesday, August 13, 2002 2:35 PM > To: Multiple recipients of list ORACLE-L > > > I run it on the server. How do I use bind variables? > > Thanks, > David > > -----Original Message----- > Sent: Tuesday, August 13, 2002 1:13 PM > To: Multiple recipients of list ORACLE-L > > > From the look of your sql statements it seems that each > statement will be hard parsed because the values are different. > If you will use bind variables you can save a lot of time. > > Is the script runs on the server or from another computer? > If you run the script from another computer you also have the > network time added. > > Yechiel Adar > Mehish > ----- Original Message ----- > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Tuesday, August 13, 2002 6:24 PM > > > > Hi all, > > > > I write a script to update 10,000 records in my database and noticed it > took > > more than an hour to update 10,000 records. The script just includes > 10,000 > > SQL update commands as shown below. Is the time too long to update 10,000 > > records? Is it a way to improve the update task to run faster. Please > > advise. > > > > *** A portion of my update script is shown below: > > > > update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id = > > 201 and lata_id = 224; > > > > update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id = > > 201 and lata_id = 224; > > > > > > Thanks, > > David > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Nguyen, David M > > 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: Yechiel Adar > 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: Nguyen, David M > 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: Khedr, Waleed > 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: Nguyen, David M > 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: Igor Neyman 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).
