Comments
| 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. |
Tim... said... Hi.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. :) Cheers Tim... |
Ted Chyn said... I ran the query on a 2 nodes cluster under Centos and got exactly the opposite result.can someone explain this.see below ================ Bulk Inserts : 678 Bulk Inserts /*+ APPEND_VALUES */ : 936 PL/SQL procedure successfully completed. |
Tim... said... Hi.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. Cheers Tim... |
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 :] |
Tim... said... Hi.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. Cheers Tim... |
Vijay said... Thanks for the simple examples you've shown to understand the benefits of the new APPEND_VALUES hint. |
DO NOT ask technical questions here, that's what my forum is for!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!