Event Trigger rerunning the DB function automatically

Hi All,

I have query in the Event Trigger->DB function returning 80000 records but the Event Trigger is running forever. It ran fine when I had rownum <= 50000. When I changed it to rownum <= 80000, by logging using autonomous transaction, I could see that it submitted the function again before it finished inserting 80000 records and committing them. the new session created waits until the first run commits 80000 records, then it creates the third session before the second one is done. it goes on and on. It takes only 4 min to insert all 80000 into a table. Obviously