top of page
  • Writer's picturekyle Hailey

Correlating SQL to Procedures

Starting in Oracle (ie not 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
   163 0uuqgjq7k12nf ORDERENTRY.NEWORDER
9 views0 comments

Recent Posts

See All

for all questions on the site, please asked them in the comment section on this blog post. Due to the enormously high amount of spam on that site, I am no longer responding to the posts

ASH explodes in Oracle 11gR2

ASH is now at 93 fields in 11gR2, starting from an original 30 in 10gR1 Here is a spread sheet across 10.1.0,,,11.1, 11.2


bottom of page