Enabling Parallel DML
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Enabling Parallel DML

  1. #1
    Join Date
    Sep 2000
    Location
    Calcutta / Ahmedabad, India
    Posts
    137

    Enabling Parallel DML

    Hi,

    In my migration script i am passing a parallel hint with degree of parallelism 4.

    Before running this script i am setting the session with

    "Alter Session Enable Parallel DML;"


    Is there any way to set the same as above at the database level ?


    Thanks
    Suvashish

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Enabling Parallel DML

    Originally posted by dsuva
    Hi,

    In my migration script i am passing a parallel hint with degree of parallelism 4.

    Before running this script i am setting the session with

    "Alter Session Enable Parallel DML;"

    Is there any way to set the same as above at the database level ?


    Thanks
    No. Not even in 9.2. But remember that you must enable parallelism in the database in order to enable parallel DML:


    parallel_automatic_tuning = true
    (parallel_adaptive_multi_user = true)

    You could try the following:

    CREATE OR REPLACE TRIGGER parallel_dml_trg AFTER LOGON ON SCHEMA
    BEGIN
    commit;
    execute immediate 'ALTER SESSION ENABLE PARALLEL DML';
    END;
    /

    There are the following restrictions on the use of alter session enable parallel dml :

    + Alter session enable|disable|force parallel dml|ddl can be executed only between transactions;

    + attempt to perform above during a txn , result in ora-12841 error.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Sep 2000
    Location
    Calcutta / Ahmedabad, India
    Posts
    137
    Hi Julian,

    Thanks for the Info.
    Suvashish

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