ooh lovely!
I'm gonna have SUCH fun today, playing with this and the results of a
10046 trace :)
--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> break on proc
> column "QUERY" format A40 word_wrapped
> select substr(KGLNAOWN || '.' || KGLNACNM, 1, 35) proc, KGLNADNM
> "QUERY"
> from x$kglrd
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 "QUE
Stephane,
My creativity has been stumulated, simulated, and mutated.
What version of Oracle are you using?
x$kglrd ...table or view does no exist on 8.1.7 rel 3
Ron
>>> [EMAIL PROTECTED] 01/10/03 05:03AM >>>
break on proc
column "QUERY" format A40 word_wrapped
select substr(KGLNAOWN || '.' || KG
Ron,
did you run it from the SYS account? worked for me using 8.1.7.2
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, January 10, 2003 10:50 AM
To: Multiple recipients of list ORACLE-L
Stephane,
My creativity has been stumulated, simulated, and mutated.
Log on as SYS and run it. I have it on my 8.1.7 DB.
Dave
-Original Message-
Sent: Friday, January 10, 2003 9:50 AM
To: Multiple recipients of list ORACLE-L
Stephane,
My creativity has been stumulated, simulated, and mutated.
What version of Oracle are you using?
x$kglrd ...table or
Title: RE: Some of you may find this useful
what is it that i am looking at after running this query??
pardon the ignorance.
chris
-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 9:20 AM
To: Multiple recipients of list ORACLE-L
Stephane and other Gurus,
Apologies if you think I am a spoilsport..
I executed 3/4 PL/SQL blocks and ran the query after each one. Every time I
got the following output. I think 'REPOS' is the OEM repository owner.
Two questions:
1. Is this what Stephane wanted us to see?
2. If yes, what does
Ron,
that's a bit of a puzzle because it should have been available since 7.3.2.
Which user are you using to query it?
Also, anyone, I know what x$kglrd does but anyone have any idea what the RD
in the table name means? Read? Row? Data? Dependency?
I'm open to suggestions.
Regards,
Mike Hately
Thanks for sharing this.
Richard
-Original Message-
Sent: Friday, January 10, 2003 5: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 !
Read Only Dependencies in the KGL.
Best Regards,
K Gopalakrishnan
-Original Message-
Mike (NESL-IT)
Sent: Friday, January 10, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L
Ron,
that's a bit of a puzzle because it should have been available since 7.3.2.
Which user are you u
Not bad at all . but now I get to ask if there is a way to improve it
...
When running the query below, the following was returned :
INSERT INTO TEMP_TABLE (
FIELD_1, FIELD_2, FIELD3 ) VALUES (
:b1,:b2,:b3 )
What I would like to know is is there any way thru Oracle to obtain the
values for
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
And what does KGL stand for ?
Thanks !
-Original Message-
Sent: ? 10 ? 2003 19:45
To: Multiple recipients of list ORACLE-L
Read Only Dependencies in the KGL.
Best Regards,
K Gopalakrishnan
-Original Message-
Mike (NESL-IT)
Sent: Friday, January 10, 2003 8:39 AM
To: Mul
Andrey Bronfin wrote:
>
> And what does KGL stand for ?
> Thanks !
[K]ernel layer [G]eneric layer [L]ibrary cache manager. Feeling better
:-) ?
> -Original Message-
> Sent: ? 10 ? 2003 19:45
> To: Multiple recipients of list ORACLE-L
>
> Read Only Dependencies in the KGL.
>
> Best
And how does one find out more information about such cryptic, undocumented
tables??
experience? R&D? be in company of more experienced people?
wat else?
Regards
Naveen
-Original Message-
Sent: Sunday, January 12, 2003 5:29 PM
To: Multiple recipients of list ORACLE-L
Andrey Bronfin wr
THANKS ;-)
-Original Message-
Sent: ? 12 ? 2003 13:59
To: Multiple recipients of list ORACLE-L
Andrey Bronfin wrote:
>
> And what does KGL stand for ?
> Thanks !
[K]ernel layer [G]eneric layer [L]ibrary cache manager. Feeling better
:-) ?
> -Original Message-
> Sent: ? 10
Naveen Nahata wrote:
>
> And how does one find out more information about such cryptic, undocumented
> tables??
>
> experience? R&D? be in company of more experienced people?
>
> wat else?
>
> Regards
> Naveen
>
Doc which should not have left Oracle? In practice, the meaning of names
you cann
Stephane you have WAY too much free time :)
seriously, I let you guys muck around the internals and I learn from
your postings. Me, I'm busy enough just trying to keep my developers
from designing tables without thought to how Oracle handles things.
--- Stephane Faroult <[EMAIL PROTECTED]> wrote
Precise Indepth for Oracle relates SQL statements to PL/SQL procedures
without quering any X$ tables. So may you should buy that, but that may
not be an option for you ;-)
Anjo.
Stephane Faroult wrote:
.
>
> My aim, remember, was to relate a PL/SQL block to the statements it
> issues, so X$KGL
Thanx a lot for a very comprehensive answer.
More than the result, I learnt the method. thanx a lot
Regards
Naveen
-Original Message-
Sent: Sunday, January 12, 2003 9:04 PM
To: Multiple recipients of list ORACLE-L
Naveen Nahata wrote:
>
> And how does one find out more information abo
Trade you users, Rachel... we still have one that thinks that silly 1000
column limit is something that I made up to make her life difficult.
April Wells
Oracle DBA
Great spirits have always encountered violent opposition from mediocre minds
-- Albert Einstein
-Original Message-
Sent:
>Stephane,
> My creativity has been stumulated, simulated, and
>mutated.
>What version of Oracle are you using?
> x$kglrd ...table or view does no exist on 8.1.7
>rel 3
>Ron
Ron,
Was on 8.1.7.3 ... sorry to ask for the obvious, but have you connected as SYS or
INTERNAL ?
Regards,
Stephane F
22 matches
Mail list logo