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)