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

Quote:

---

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.

Hi Julian,

Thanks for the Info.