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

Thread: Parallel Delete - DML

  1. #1
    Join Date
    Jul 2001
    Posts
    108

    Parallel Delete - DML

    Hello,

    I would like to delete approx. 15 Miilion records from a single partition table (nonpartitioned table).

    Can I run a parallel DML delete statement to get rid of all the records from a table?

    Thanks,
    Nikee

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439

    Re: Parallel Delete - DML

    Originally posted by Nikee
    Can I run a parallel DML delete statement to get rid of all the records from a table?
    If you want to get rid of *all of your records* from a table, then what's the point in using DML delete statement at all? Why not simply using TRUNCATE istead? Uncomparable faster and it resets the HWM on the table at the same time.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Yes. You can do parallle delete on unpartitioned table.

    The steps I used in 9i are:

    Alter session enable parallel query;

    Alter session enable parallel dml;

    alter table table_A parallel 6;

    delete from table_A where colA = 'xxxx';

    commit;

    alter table table_A noparallel;

    Tamil

  4. #4
    Join Date
    Jul 2001
    Posts
    108
    Hello Tamilselvan,

    Thanks for the response.

    How about nologging option? I have already turned off the Archive log mode.

    At this point, will the nologging option is useful?
    Or nologging is good only in the archive mode?

    Thanks,
    Nikee

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Why dont u take Jurij's suggestion?????


    Well even if you may want to retain 25% of Rows then insert into some temp table the desired recs and truncate main table.. then insert back the reocords from temp table. ( with all those parallel, nologging, noindexes and all that stuff )
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  6. #6
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    NOLOGGING is no effect with delete operation.

    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