DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Parallel DML for UPDATE

  1. 11-08-2005, 03:40 PM #1
    bang_dba
    bang_dba is offline Senior Member
    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
    Reply With Quote Reply With Quote
  2. 11-08-2005, 03:47 PM #2
    dbasan's Avatar
    dbasan
    dbasan is offline Advisor
    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"
    Reply With Quote Reply With Quote
  3. 11-08-2005, 03:52 PM #3
    tamilselvan
    tamilselvan is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
  4. 11-08-2005, 04:04 PM #4
    bang_dba
    bang_dba is offline Senior Member
    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
    Reply With Quote Reply With Quote
  5. 11-08-2005, 04:12 PM #5
    dbasan's Avatar
    dbasan
    dbasan is offline Advisor
    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"
    Reply With Quote Reply With Quote
  6. 11-08-2005, 04:41 PM #6
    tamilselvan
    tamilselvan is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width