Logon Trigger Alter Session cmds not doing anything 19.17
From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Fri, 16 Jun 2023 08:47:02 -0400
Message-ID: <CAP79kiTuS9fkuHHURebWEV9Cj6Ro3xU6fJkSqSvR8Yy=nH3Ytw_at_mail.gmail.com>
I'm a bit puzzled by this one. I'm trying to limit parallel processes/slaves for one particular user and I've created a logon trigger that does this:
CREATE or replace TRIGGER user_redacted.logon_trigger AFTER logon ON schema
enable
BEGIN
execute immediate 'alter session set parallel_threads_per_cpu=1'; execute immediate 'alter session set parallel_degree_policy=''ADAPTIVE''';
Date: Fri, 16 Jun 2023 08:47:02 -0400
Message-ID: <CAP79kiTuS9fkuHHURebWEV9Cj6Ro3xU6fJkSqSvR8Yy=nH3Ytw_at_mail.gmail.com>
I'm a bit puzzled by this one. I'm trying to limit parallel processes/slaves for one particular user and I've created a logon trigger that does this:
CODE:
CREATE or replace TRIGGER user_redacted.logon_trigger AFTER logon ON schema
enable
BEGIN
execute immediate 'alter session set parallel_threads_per_cpu=1'; execute immediate 'alter session set parallel_degree_policy=''ADAPTIVE''';
execute immediate 'alter session set parallel_degree_limit=4';
END;
/
I logon to that schema (in a PDB) after creating the trigger (in the PDB) and none of those params take effect.
I can alter those params in a session as that user with no problem, but the
trigger isn't doing it. Even tried doing a database-wide trigger and checking if the user is my user of interest. Still nada.I'm clearly missing something and hoping you guys can point me to something obvious?
The user does NOT have DBA role but does have a lot of system privileges like "CREATE ANY" , "DROP ANY" privs (for some reason from the past).
Thanks,
Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 16 2023 - 14:47:02 CEST