For some reason we don't see a query (and sqll_id ) executed inside a trigger in the Monitor Sessions or Real Time SQL Monitor.
The insert trigger calls a package procedure, which calls another procedure, that executes the query before updating another table.
The package call does come up in both monitors...
Any idea why this could be happening?