In our database tables there are many triggers, about 5 for a single table.
Ok, it's not the best and I've already fight for this.
So now the requirement is to update without fire some triggers.
To do this developer modify triggers adding the select from v$session
DECLARE
sinfo VARCHAR2(200);
BEGIN
Select Client_Info into sinfoFrom V$SESSION Where AudSid = UserEnv('SESSIONID');
If InStr(Coalesce(sinfo, 'X'), '*NOTRIGGER*' ) = 0 then
.....
END IF;
END;
and then execute the update procedure doing this before:
DBMS_APPLICATION_INFO.Set_Client_Info ('*NOTRIGGER*');
so every time the trigger fire, query from v$session is performed with high impact on performance.
Is there any other method to bypass a trigger for some program or users?