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-

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:

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 Regards,

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? RD? 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

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? RD? 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 cannot guess

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$KGLRD

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

Some of you may find this useful

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

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 where

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 QUERY

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 || '.' || KGLNACNM,

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

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

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: 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 Faroult

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

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

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