Re: what package/procedure did SQL come from?
- From: Jurijs Velikanovs <j.velikanovs@xxxxxxxxx>
- To: Mark.Bobak@xxxxxxxxxxxx
- Date: Wed, 3 Jun 2009 18:57:48 +1000
Cool! Does anyone have a suggestion how safe it is to use this X$ view
in busy system?
Yury.
On Wed, Jun 3, 2009 at 6:30 PM, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx> wrote:
> 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
>
>
>
--
Jurijs
+371 29268222 (+2 GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
--
//www.freelists.org/webpage/oracle-l
Other related posts:
