GV$LOGSTDBY_STATS definition in Oracle 10g / www.oracledba.ru
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
where
name != 'LMNR_SID'
union all
select
inst_id,
name,
to_char (value)
from
(
select
inst_id,
session_id,
name,
value
from
x$krvxsv
where
flags = 0)
where
session_id = (
select
value
from
x$krvslvs
where
name = 'LMNR_SID'))
where
exists (
select
1
from
v$session s,
x$knstacr x
where
s.sid=x.sid_knst and s.serial#=x.serial_knst)