I cannot determine how to update a table and not fire the trigger on it.
Example: We have a trigger to audit changes to a table. We have an area of our software where we want to insert some new records automatically, this happens often and does not need to be audited. However, other changes to this table must be audited.
How can I perform these inserts without firing the trigger?
I do not want to disable the trigger often because someone else may be inserting records at this same time.
You can't conditionally disable the trigger, but you can set a session variable that would be able to be read by the trigger to determine if it is to skip it's audit. Check out the information on DBMS_SESSION.SET_CONTEXT
You do not need a parachute to skydive. You only need a parachute to skydive twice.