Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

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.
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired