|APPEND_VALUES Hint in Oracle Database 11g Release 2 - Use the APPEND_VALUES hint to perform direct-path inserts when using the FORALL statement.|
lesio said...APPEND should work like APPEND_VALUES !
Oracle is crazy, another thing to remember.
APPEND is only supported in "INSERT INTO ... SELECT" statments. If you use in an "INSERT INTO ... VALUES" statement it is ignored.
I agree, it would have been nice if they had just used the same hint text in the two statements. :)
Ted Chyn said...I ran the query on a 2 nodes cluster under Centos and got exactly the opposite result.can someone explain this.
Bulk Inserts : 678
Bulk Inserts /*+ APPEND_VALUES */ : 936
PL/SQL procedure successfully completed.
No idea. I guess you need to trace it to see what the extra time is taken up doing. Use SQL Trace with waits switched on.
DarkAngelStrike said...URLs to the Oracle Documentation has changed :
About Direct-Path INSERT >> download.oracle.com/docs/cd/E11882_01/server.112/e17120/tables004.htm#i1009864
APPEND_VALUES Hint >> download.oracle.com/docs/cd/E11882_01/server.112/e17118/sql_elements006.htm#SQLRF51109
Thanks for the heads-up. It seems Oracle change the URLs every time they release a new patchset these days. :)
I've corrected the links in the article now.
Vijay said...Thanks for the simple examples you've shown to understand the benefits of the new APPEND_VALUES hint.