Parallel DML for UPDATE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Parallel DML for UPDATE

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    Parallel DML for UPDATE

    Hi,

    Is it possible to enable parallel DML to a non-partitioned table for an UPDATE statement ?
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway

  2. #2
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by bang_dba
    Hi,

    Is it possible to enable parallel DML to a non-partitioned table for an UPDATE statement ?
    Not possible!
    "What is past is PROLOGUE"

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Quote Originally Posted by dbasan
    Not possible!


    Yes, Possible if your DB is >= 8i.
    Tamil

  4. #4
    Join Date
    Sep 2002
    Posts
    376
    Quote Originally Posted by tamilselvan


    Yes, Possible if your DB is >= 8i.
    Tamil

    Thx Tamil. Just alter session with Hint will do OR is there any other setting to be done ?
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway

  5. #5
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by tamilselvan


    Yes, Possible if your DB is >= 8i.
    Tamil
    you are right Tamil, but don't talk abt expired versions!
    "What is past is PROLOGUE"

  6. #6
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Quote Originally Posted by dbasan
    you are right Tamil, but don't talk abt expired versions!
    Expired versions ??? What are they?

    Tamil

Posting Permissions

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


Click Here to Expand Forum to Full Width