Re: Enabling Parallel DML
No. Not even in 9.2. But remember that you must enable parallelism in the database in order to enable parallel DML:
Originally posted by dsuva
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 ?
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
execute immediate 'ALTER SESSION ENABLE PARALLEL DML';
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.