enable parallel dml for 1 user only
Hi, i need to enable parallel dml for 1 specific users only.
I do not want to enable this for other users.
How can i implement this?
after logon trigger?
is there other methods?
Cannot explicitely run this:
alter session enable parallel dml;
because that user connects with software i have no control over it.
Use logon trigger and check for the user name.
Logon trigger does not work:
sys> create or replace trigger logon_trigger
after logon on database
if ( user = 'MS' ) then
execute immediate('alter session enable parallel dml');
sys@MUS_PROD> connect ms/poc2007@mus-dev
ORA-00604: error occurred at recursive SQL level 1
ORA-12841: Cannot alter the session parallel DML state within a transaction
ORA-06512: at line 3
hmm, off the top of my head I'd say either a resource group, or a profile. I'm not sure either can restrict parallel, though...
you can restrict parallel degree using resource manager
Click Here to Expand Forum to Full Width