Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Disable trigger at a session level

NarendraPMay 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
758 views