There is nothing “evil” about database triggers – they just have to be used where they can actually solve problems. In this presentation, various kinds of triggers will be examined from a global system optimization point of view that includes not only the aspect of functional correctness, but also the tradeoffs between multiple goals. For example, depending upon the available hardware, developers can select either CPU-intensive or I/O-intensive solutions. This presentation will focus on the most common performance problems related to different kinds of DML triggers and the proper ways of resolving them.
Performance Tuning Aspects of DML Triggers
Watch the full-length video
You’ve reached the ultimate Oracle customer network—exclusively for Quest Corporate and Professional members.
Join Quest to unlock access to strategic content centers, event replays, exclusive programming, and expert insights—all designed to help Oracle users like you go further, faster.
Whether you're on JD Edwards, PeopleSoft, or Oracle Cloud, Quest connects you with a powerful peer network and Oracle experts so you can make smarter decisions, drive innovation, and get more from your investment.
Quest is where Oracle customers connect, learn, and lead with confidence. Ready to join them?