The amusing part is how I first learned of this X$..... Years ago, in the days of 8i, I think, I found a script on MetaLink that would provide the name of the stored PL/SQL object, given a SQL statement. But, the script itself was wrapped PL/SQL. The ironic part was, the string 'X$KGLRD' was visible, even in the wrapped source. :-) Once I noticed that, it didn't take too long for me to experiment a bit and figure out how to directly use this X$, so I no longer needed the wrapped PL/SQL. :-) So, in this case, at least, wrapping wasn't very effective... :-) -Mark P.S. FYI, I just did a MetaLink search on x$kglrd, and got a couple of hits on a script that shows an example of how to join to x$kglob and x$kglcursor. ________________________________________ From: Tanel Poder [tanel@xxxxxxxxxx] Sent: Wednesday, June 03, 2009 4:16 To: Bobak, Mark; oracle-l@xxxxxxxxxxxxx Subject: RE: what package/procedure did SQL come from? Nice one, Mark! I thought that v$object_dependency had x$kglrd in it too but I just checked, it only has x$kgldp.. Thanks, -- Regards, Tanel Poder http://blog.tanelpoder.com > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark > Sent: 03 June 2009 01:35 > To: kylelf@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx > Subject: RE: what package/procedure did SQL come from? > > Ah ha! > > I was thinking about this yesterday....I could have sworn I > learned this at some point in the past, but then > forgot....and after much digging yesterday, I got busy w/ > other stuff and forgot about it. > > Well, today, I was swamping though some X$ tables, in pursuit > of other information, and I stumbled across it!! > > See X$KGLRD for the information you're looking for! -- //www.freelists.org/webpage/oracle-l