GV$LOGSTDBY_STATS definition in Oracle Database 11.2
GV$LOGSTDBY_STATS

select
  inst_id,                                 -- INST_ID NUMBER
  name,                                    -- NAME VARCHAR2(64)
  value                                    -- VALUE VARCHAR2(64)
from
  (
  select
    inst_id,
    name,
    value
  from
    x$krvslvs
union all
select
  inst_id,                                 -- INST_ID NUMBER
  name,                                    -- NAME VARCHAR2(64)
  to_char(value)                           -- VALUE VARCHAR2(64)
from
  (
  select
    inst_id,
    session_id,
    name,
    value
  from
    x$krvxsv
  where
    bitand(flags, 2) = 2)where session_id = (
  select
    value
  from
    x$krvslvs
  where
    name = 'logminer session id'))
where
exists (
select
  1                                        -- INST_ID NUMBER
from
  v$session s,
  x$knstacr x
where
  s.sid=x.sid_knst and s.serial#=x.serial_knst)

home |  up