Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....

  • From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
  • To: cichomitiko@xxxxxxxxx
  • Date: Tue, 1 Nov 2011 23:58:37 -0700

The reason you see the NO_PARALLEL in the outline because you have not
calibrated your IO for auto DOP to work as shown by the Notes section.
 After doing so you should see the SHARED directive show up in its
place.  It's still using PX and you can see this from looking at
v$pq_tqstat from the same session you ran the query.  One can also
look at the SQL Monitor Report as well.

Using scott.emp might be a poor example because there is only 1
granule for the table scan so only 1 PX server gets work.


On Tue, Nov 1, 2011 at 2:45 PM, Radoulov, Dimitre <cichomitiko@xxxxxxxxx> wrote:
>
> Hi Mark,
> yes, the documentation is clear.
>
> Actually I should have said:  the append hint was ignored (not *only*
> the append hint was ignored).
>
> I mean that, if I'm reading this correctly, the plan output alone is not
> sufficient to determine if the table TEST
> is accessed in parallel or only the table CS_CONTENT_XML_DATA is read in
> parallel.
>
> With a simple test I'm getting the following output:
>
> insert  into   emp_1 select  /*+ parallel */   * from   scott.emp
>
> Outline Data
> -------------
>
>   /*+
>       BEGIN_OUTLINE_DATA
>       IGNORE_OPTIM_EMBEDDED_HINTS
>       OPTIMIZER_FEATURES_ENABLE('11.2.0.3')
>       DB_VERSION('11.2.0.3')
>       ALL_ROWS
>       NO_PARALLEL
>       OUTLINE_LEAF(@"SEL$1")
>       OUTLINE_LEAF(@"INS$1")
>       FULL(@"INS$1" "EMP_1"@"INS$1")
>       FULL(@"SEL$1" "EMP"@"SEL$1")
>       END_OUTLINE_DATA
>   */
>
> Note
> -----
>    - automatic DOP: skipped because of IO calibrate statistics are missing
>

-- 
Regards,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2011