Forum Stats

  • 3,874,905 Users
  • 2,266,789 Discussions
  • 7,912,003 Comments

Discussions

Disable trigger at a session level

It would be useful if we are allowed to disable triggers only for current session. The presence of (enabled) triggers prevents a DML from running in parallel.

If we are allowed to disable trigger in a session, we can have batch jobs (like archival) that can benefit from having option to go parallel while allowing other transactional sessions to continue to operate with trigger functionality.

Disabling trigger at a session level can get recorded either in audit or in alert logs for traceability.

Tagged:
User_S1J6PUser_OGIDSRainer StenzelMike Kutz
4 votes

Active · Last Updated

Comments