I have table on which some DML triggers are created to log some specific
information on the DML operation being carried out. One day on single
session, all the DMLs fired by an user have been captured except one.
That means, for a particular DML the trigger was not fired. But
everything was normal and no error/exception was thrown by Oracle as the
user has successfully committed the changes. We are unable to detect why
the trigger was not fired as same kind of DMLs in the same session
caused the trigger to fire successfully.
Does any one have this same kind experience? Is it possible that huge
network traffic or too much load in the table may cause such abnormal
behaviour?
Thanks & Regards,
Manash Partim Baruah
MS-LCS| DBA| Tech Mahindra Ltd.
Sharda Center, 6th Floor Annex Building, Pune-4, India
www.techmahindra.com <http://www.techmahindra.com>
============================================================================================================================
Disclaimer:
This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.
============================================================================================================================
Oracle LazyDBA home page