I have applied a trigger on inserts of a table. The triger might execute for 10 or more seconds depending upon the data in the table. The trigger might affect other tables as well. When a record is inserted into the table, the triger fires and starts executing. Now suppose that as soon as the trigger fires, another record is inserted. Logically, another instance of the trigger must fire and start executing.