-
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
-
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,12c
email: ocp_9i@yahoo.com
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|