RE: Some of you may find this useful

It looks like all of the SQL executed from the named packages.

I found two references to the voodoo that is x$kglrd, both from the venerable Steve Adams' ixora.com.au:

http://www.ixora.com.au/q+a/0110/31164749.htm http://www.ixora.com.au/scripts/library.htm#package_sql_executions

S-

On Fri, 10 Jan 2003, Chris Stephens wrote:

>
> what is it that i am looking at after running this query??
>
>
> pardon the ignorance.
> chris
> -----Original Message-----
> Sent: Friday, January 10, 2003 9:20 AM
> To: Multiple recipients of list ORACLE-L
>
>
> That's pretty cool :)
> Thanks for sharing it, Stephane.
>
> - Kirti
>
> -----Original Message-----
> Sent: Friday, January 10, 2003 4:04 AM
> To: Multiple recipients of list ORACLE-L
>
>
> break on proc
> column "QUERY" format A40 word_wrapped
> select substr(KGLNAOWN || '.' || KGLNACNM, 1, 35) proc, KGLNADNM "QUERY"
> from x$kglrd
> where KGLNAOWN != 'SYS'
> order by 1, kgldepno
> /
>
> If it doesn't stimulate your creativity I can do nothing for you :-).
>
> Regards,
>
> Stephane Faroult
> Oriole
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephane Faroul
> INET: sfaroult_at_oriolecorp.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Deshpande, Kirti
> INET: kirti.deshpande_at_verizon.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Steve Rospo
  INET: srospo_at_watchmark.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).