System Triggers

System triggers let you audit server startup and shutdown, server errors, and user logon and logoff activities. They’re convenient for tracking the duration of connections per user and the uptime of the database server.

They’re available only in the Oracle database because MySQL doesn’t implement them.

Oracle System Triggers

Oracle system triggers are handy for administrative reasons and are the purview of the DBA. They provide the ability to track user behaviors and become predictive of ad hoc load behaviors when business entities enable query-only schemas on production servers. Query-only schemas support day-to-day reporting engines and are the way many businesses replicate their data sets to make them available to accounting, finance, and operations staff. System triggers can let a DBA track down users who run nonperformant (cool industry-specific word that means grossly inefficient) queries.