This discussion is archived
4 Replies Latest reply: Nov 19, 2012 10:35 AM by 6363 RSS

Append hint..

phanimarella Newbie
Currently Being Moderated
Hi all..

Please help me with the following quesion.
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
I have the following scenario.

Job1 "insert" the data into "Table1".
Job1 Insert commands has ""append hint" in it. Job1 has lot of "Inserts with append hint" that
inserts the data into "table1".

Job2 "inserts" the data into "Table1" only.
Job2 insert command doesn't have append hint.

If both job1 and job 2 ""runs parallely"", do the ""append"" hint blocks the other jobs.

Does append hint give any problem in this scenario?

please let me know.
  • 1. Re: Append hint..
    sb92075 Guru
    Currently Being Moderated
    phani marella wrote:
    Hi all..

    Please help me with the following quesion.
    Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
    I have the following scenario.

    Job1 "insert" the data into "Table1".
    Job1 Insert commands has ""append hint" in it. Job1 has lot of "Inserts with append hint" that
    inserts the data into "table1".

    Job2 "inserts" the data into "Table1" only.
    Job2 insert command doesn't have append hint.

    If both job1 and job 2 ""runs parallely"", do the ""append"" hint blocks the other jobs.

    Does append hint give any problem in this scenario?

    please let me know.
    no problem
  • 2. Re: Append hint..
    rp0428 Guru
    Currently Being Moderated
    >
    If both job1 and job 2 ""runs parallely"", do the ""append"" hint blocks the other jobs.

    Does append hint give any problem in this scenario?
    >
    Direct-path insert will lock the segment. No concurrent DML is allowed. So the second job cannot insert until the direct-path insert is completed and a commit or rollback is performed.

    If job 2 starts first and is already doing DML then job1 will run but it will NOT use direct-path insert even though the APPEND hint is used.

    See this other thread from this morning.
    Insert Into Select with APPEND hint
  • 3. Re: Append hint..
    phanimarella Newbie
    Currently Being Moderated
    Thank u rp..

    even the following blog also says that "append" might give an issue.
    http://appcrawler.com/wordpress/2010/10/14/careful-with-that-append-hint/
    may be i need to remove the append hint from the process.

    Thank u..
  • 4. Re: Append hint..
    6363 Guru
    Currently Being Moderated
    phani marella wrote:

    even the following blog also says that "append" might give an issue.
    http://appcrawler.com/wordpress/2010/10/14/careful-with-that-append-hint/
    All features might give issues if they are not used properly.
    may be i need to remove the append hint from the process.
    You can use the same reasoning to delete and remove all code.

    Is the append hint used properly?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points