GV$EXECUTION definition in Oracle Database 11.2
GV$EXECUTION

select
  inst_id,                                 -- INST_ID NUMBER
  pid,                                     -- PID NUMBER
  val0,                                    -- DEPTH NUMBER
  func,                                    -- FUNCTION VARCHAR2(10)
  decode(                                  -- TYPE VARCHAR2(7)
    id,1,'call',2,'return',3,'longjmp'),
  nvals,                                   -- NVALS NUMBER
  val2,                                    -- VAL1 NUMBER
  val3,                                    -- VAL2 NUMBER
  seqh,                                    -- SEQH NUMBER
  seql                                     -- SEQL NUMBER
from
  x$kstex
where
  op=10

home |  up