Skip to main content

Posts

Showing posts from August, 2013

How do I get to see the procedures that are running

How do I get to see the procedures that are running
SELECT   SUBSTR (DECODE (o.kglobtyp, 7, 'PROCEDURE'), 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;


Note that, You should have the privilege on SYS.x$kglob , SYS.x$kglpn and SYS.x$ksuse .

Cheers

HSC result 2013

HSC result 2013
Today publish HSC result 2013. For easily get result visit....
HSC result 2013
WE give our well wishes to student who are participate HSC examination of 2013.

Cheers !!!