-
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.
Tamil
-
Logon trigger does not work:
sys> create or replace trigger logon_trigger
after logon on database
begin
if ( user = 'MS' ) then
execute immediate('alter session enable parallel dml');
end if;
end;
/
sys@MUS_PROD> connect ms/poc2007@mus-dev
ERROR:
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...
Jeff Hunter
-
Hi
you can restrict parallel degree using resource manager
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
|