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,
name,
to_char (value) 
from
(
select
inst_id,
session_id,
name,
value 
from
x$krvxsv) 
where
session_id = (
select
value 
from
system.logstdby$parameters 
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)
home |  up  |  mailbox