Re: Some of you may find this useful

2003-01-10 Thread Rachel Carmichael
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

RE: Some of you may find this useful

2003-01-10 Thread Deshpande, Kirti
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

Re: Some of you may find this useful

2003-01-10 Thread Ron Rogers
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

RE: Some of you may find this useful

2003-01-10 Thread Mercadante, Thomas F
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.

RE: Some of you may find this useful

2003-01-10 Thread Farnsworth, Dave
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

RE: Some of you may find this useful

2003-01-10 Thread Chris Stephens
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

RE: Some of you may find this useful

2003-01-10 Thread Charu Joshi
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

RE: Some of you may find this useful

2003-01-10 Thread Hately, Mike (NESL-IT)
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

RE: Some of you may find this useful

2003-01-10 Thread Richard Ji
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 !

RE: Some of you may find this useful

2003-01-10 Thread K Gopalakrishnan
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

RE: Some of you may find this useful

2003-01-10 Thread Kevin Lange
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

RE: Some of you may find this useful

2003-01-10 Thread Steve Rospo
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

RE: Some of you may find this useful

2003-01-12 Thread Andrey Bronfin
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

Re: Some of you may find this useful

2003-01-12 Thread Stephane Faroult
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

RE: Some of you may find this useful

2003-01-12 Thread Naveen Nahata
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

RE: Some of you may find this useful

2003-01-12 Thread Andrey Bronfin
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

Re: Some of you may find this useful

2003-01-12 Thread Stephane Faroult
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

Re: Some of you may find this useful

2003-01-12 Thread Rachel Carmichael
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

Re: Some of you may find this useful

2003-01-12 Thread Anjo Kolk
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

RE: Some of you may find this useful

2003-01-12 Thread Naveen Nahata
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

RE: Some of you may find this useful

2003-01-13 Thread April Wells
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:

RE: Re: Some of you may find this useful

2003-01-10 Thread Stephane Faroult
>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