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).