Oracle - Recursive calls caused by data modification (triggers, function based index, ...)

When you are doing data modification, you can fired many side effects as :

• trigger
• function-based index
• …

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