Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Disable trigger at a session level

User_S1J6PMay 23 2022

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.

Comments
Post Details
Added on May 23 2022
2 comments
271 views