Starting in Oracle 10.2.0.3 (ie not 10.2.0.2 and below) it’s easy to track what package and/or procedure a SQL execution came from using v$session and or v$active_session_history (ASH) which have the new fields
COUNT(*) SQL_ID calling_code
-------- ---------- ----------------------------------
2 1xxksrhwtz3zf OE.NEWORDER => DBMS_RANDOM.VALUE
2 1xxksrhwtz3zf OE.NEWORDER => DBMS_LOCK.SLEEP
13 1xxksrhwtz3zf OE.NEWORDER
76 dw2zgaapax1sg OE.NEWORDER
131 75621g9y3xmvd OE.BROWSEANDUPDATEORDERS
163 0uuqgjq7k12nf ORDERENTRY.NEWORDER
using SQL like ( http://www.perfvision.com/ash/ashpl2.sql)
Comments