Database Administration (MOSC)

MOSC Banner

Disable Parallel Query for Spesific User

edited Apr 7, 2015 10:05AM in Database Administration (MOSC) 2 commentsAnswered

Hi All,

I want to prevent a spesific user which is executing all select or dml querys parallel. (The user is executing all select * from table or update table queries parallely with /*+ PARALLEL(16) */ hints. And I need to prevent this situation.)

I have written below Logon Trigger but it doesn't work.

Can anyone help me what is problem or if it exists another solutions ?

create or replace trigger disable_parallel

after logon on <spesific_user_name>.schema

BEGIN

execute immediate 'ALTER SESSION DISABLE PARALLEL DML';

END;

/

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center