Faster Inserts!

[@berndeckenfels]

I like the MySQL syntax for multiple values, it is not as flexible as the multi table insert but more compact.

[@hellohiavi]

Great approach

[@halilyou1985]

Dear Connor, What would be your advice to use this method for inserting 300 millions of row. I have a large Ledger transaction table and I am using conventional insert into select * from ... approach with /*+ APPEND PARALLEL(T,32) */ hint and "ALTER SESSION ENABLE PARALLEL DML" settings. Thank you

[@DatabaseDude]

300 million rows is not a "lot", so if its taking a LONG time, then something else is holding it back. Try a 10046 trace to see where the time is being lost

[@halilyou1985]

@@DatabaseDudeI see that, thank you for your feedback. 😊

[@ravinbharathmaharaj9269]

Hi Connor. Thank you for this tip. Please provide a link for the 'as_insert' function. I checked your blog and I having difficulty in finding it. Thank You

[@DatabaseDude]

connor-mcdonald.com/2019/05/17/hacking-together-faster-inserts/

[@marcinbadtke]

Thank you

[@DatabaseDude]

You're welcome

[@osama2osama]

Am quite happy with your videos, but on thing that bother me is the sql plus colors, can you make your code/Examples explanation on any development tool such as sql developers or TOAD Thanks Mr. Connor

[@DatabaseDude]

I'm a SQL Plus guy :-)

[@DatabaseDude]

but feel free to suggest alternate colors

[@osama2osama]

Connor McDonald i can say a white background with black font ink will do the job ,and will be very clear to read and follow. Thanks again for answering my concern

[@haroon9445]

Very Large Insert All Command May Consume PGA, Leading to ORA-4036 or ORA-700[over pga_aggregate_limit] (Doc ID 2273886.1)

[@pushpakpattewar7098]

Need help Our inserts are coming from application and inserted in only in one table . no issue of parsing as sql id is same help us with what parameters we can change at db or table level .??for faster insertion . db-Oracle 11g

[@DatabaseDude]

check out this video which might be appropriate ... kzbin.info/www/bejne/m2LEkIiBpq2Ab7s But yeah...its time get off 11g

[@a.useronly2266]

Great

[@carlosmatos9216]

How can I do this using Oracle Developer? I searched, but only found about SQL Server. Greetings from Brazil.

[@DatabaseDude]

Just load the AS_INSERT procedure into your database and you'll be good to go. connor-mcdonald.com/2019/05/17/hacking-together-faster-inserts/ The /*insert*/ hint also works in SQL Developer but you need to run your SQL as a script (F5) not a command (F9)

[@eddiehapson1730]

Nice

[@abouyasserislam786]

Plz link to download as_insert script

[@DatabaseDude]

connor-mcdonald.com/2019/05/17/hacking-together-faster-inserts/

[@abouyasserislam786]

@@DatabaseDude THANKS

[@maxmcdonald4537]

#beast