CODEWITHSUNDEEP
databaseoracle-databasetriggersstatistics
Sean
Sean

Reputation: 33

Track Oracle DB Trigger usage

Does anyone know if it is possible to track how often triggers are initiated? and also check the outcome of the trigger, i.e updates or any error messages that triggers produced?

Cheers

Upvotes: 0

Views: 80

Answers (1)

golosovsky
golosovsky

Reputation: 718

You can add any logging logic you want to the trigger -- you can add an insert to a log table and write the new (:new.<col>) and old (:old.<col>) values.

You can also use Audit.

Upvotes: 1

Related Questions