Re: Enabling Parallel DML
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.