Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    66

    Unanswered: Insert statement with Parallel direct load

    Hi,

    I'm running the query below in Explain Plan window:

    INSERT /*+ PARALLEL(emp,12) */ INTO emp
    SELECT /*+ PARALLEL(t_emp,12) */ * FROM t_emp;

    In "Other Tag" option in Explain Plan ,
    For SELECT statement it's showing PARALLEL_TO_SERIAL
    But
    For INSERT statement it's showing Nothing (NULL).

    As far I know , INSERT /*+ PARALLEL(emp,12) */ INTO emp
    means PARALLEL execution mode with APPEND (default for PARALLEL).

    Then why it's not showing in EXPLIAN PLAN ?
    Is the INSERT statement not running in PARALLEL?

    Any help will be highly appreciated ..
    himridul

  2. #2
    Join Date
    Jan 2004
    Posts
    66
    plz any help regarding this .....
    himridul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •