How to fire multiple Oracle DB triggers at the same time

Hi All,

We have a performance issue in our PRD environment. To improve the scenario, we came up with DB Trigger approach. But it is not working. Any guidance on triggers will be of great help for us.

Current Scenario:-

===========================================================

Oracle DB Procedures calls the below DB Functions in a serial manner. DB Function C runs for 1 day, which degrades the performance of the environment.

DB Function A

DB Function B

DB Function C (runs for all business units)

New Approach:-

=============================================================

We are planning to split DB Function C into 2 DB Functions (Function C1 & Function C2) . The new sequence will be:-