When you are doing data modification, you can fired many side effects as :
which include also other SQL statement and improve then the recursive calls metrics.
You can avoid it by :
- avoiding as much recursive SQL as possible
- moving SQL out of the trigger into a package