monitor trigger execution

[[email protected]]

The trigger is a block of SQL, which SHOULD turn up in any trace file for using TKPROF.

that should show you the time, I believe.