Thanks very much Jamadagni, It works fine.
Another question, I issued a huge select, ran the script and it appeared. I cancelled the select and it still showed up in the result script like for more than 3 minutes, exited the session and dissapeared. Is this the normal behavior ?? Tks I am satisfied with the solution. Ramon ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 11, 2002 1:00 PM > decode(kglobtyp,0,'CURSOR',7,'PROCEDURE',8,'FUNCTION',9,'PACKAGE', > 11,'PACKAGE BODY',12,'TRIGGER',13,'TYPE',14,'TYPE BODY','OTHER') > > Raj > ______________________________________________________ > Rajendra Jamadagni MIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. > > QOTD: Any clod can have facts, but having an opinion is an art! > > > -----Original Message----- > Sent: Thursday, July 11, 2002 1:19 PM > To: Multiple recipients of list ORACLE-L > > > Jamadagni, > > Tks for the help. > > After creating the xviews it worked fine for function, packages, procedures. > > I want to include SQL statements also. Was checking > but just return numbers, that explain the decode. > > select distinct kglobtyp from X_$KGLOB > > KGLOBTYP > ---------- > 0 > 1 > 2 > 3 > 4 > 5 > 6 > 7 > 8 > 9 > 10 > > > What is the number for SQL statements ??? or > > Which one is the table of description for the numbers in the X_$KGLOB view ? > > TIA > > Ramon > > > > > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, July 03, 2002 3:26 PM > > > > http://www.ixora.com.au/scripts/sql/create_xviews.sql > > > > Raj > > ______________________________________________________ > > Rajendra Jamadagni MIS, ESPN Inc. > > Rajendra dot Jamadagni at ESPN dot com > > Any opinion expressed here is personal and doesn't reflect that of ESPN > Inc. > > > > QOTD: Any clod can have facts, but having an opinion is an art! > > > > > > -----Original Message----- > > Sent: Wednesday, July 03, 2002 3:44 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Jamadagni > > > > I am getting an error > > > > sys.X_$KSUSE s > > * > > ERROR at line 12: > > ORA-00942: table or view does not exist > > > > Tested on 8.1.7 and 9.0.1 and the same error. > > > > What script should I run to create that table or view ? > > > > TIA > > > > Ramon > > > > > > ----- Original Message ----- > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Wednesday, July 03, 2002 1:13 PM > > > > > > > prompt **** Currently Executing Packages **** > > > SELECT > > > substr(DECODE(o.kglobtyp, > > > 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 12, 'TRIGGER', 13, > > > 'CLASS'),1,15) "TYPE", > > > substr(o.kglnaown,1,30) "OWNER", > > > substr(o.kglnaobj,1,30) "NAME", > > > s.indx "SID", > > > s.ksuseser "SERIAL" > > > FROM > > > sys.X_$KGLOB o, > > > sys.X_$KGLPN p, > > > sys.X_$KSUSE s > > > WHERE > > > o.inst_id = USERENV('Instance') AND > > > p.inst_id = USERENV('Instance') AND > > > s.inst_id = USERENV('Instance') AND > > > o.kglhdpmd = 2 AND > > > o.kglobtyp IN (7, 8, 9, 12, 13) AND > > > p.kglpnhdl = o.kglhdadr AND > > > s.addr = p.kglpnses > > > ORDER BY 1, 2, 3 > > > / > > > > > > > > > Courtsy of Steve Adams. > > > > > > Raj > > > ______________________________________________________ > > > Rajendra Jamadagni MIS, ESPN Inc. > > > Rajendra dot Jamadagni at ESPN dot com > > > Any opinion expressed here is personal and doesn't reflect that of ESPN > > Inc. > > > > > > QOTD: Any clod can have facts, but having an opinion is an art! > > > > > > -----Original Message----- > > > Sent: Wednesday, July 03, 2002 11:39 AM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > Hi gurus, > > > > > > Is there any way to know which SQL statement or procedure or package is > > > running actually. > > > > > > I checked in V$SQLTEXT, V$SQLAREA joined with V$SESSION and could get > the > > > statement, the user but this process had already finished, it was just > in > > > the SGA. > > > > > > What I want to know is who is actually running something in the DB. > > > > > > TIA > > > > > > > > > Ramon E. Estevez > > > [EMAIL PROTECTED] > > > 809-565-3121 > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Ramon E. Estevez > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing Lists > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (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.com > -- > Author: Ramon E. Estevez > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
