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.

DO NOT ask technical questions here! They will be deleted!

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!

Add your comments here.
Name
Comment
(max 400 chars - plain text)