DBA Data[Home] [Help]

APPS.FND_ADG_MANAGE dependencies on V$MYSTAT

Line 78: where a.sid = ( select distinct b.sid from v$mystat b);

74: from v$database a;
75:
76: cursor c2 is select a.sid,a.serial#,a.audsid
77: from v$session a
78: where a.sid = ( select distinct b.sid from v$mystat b);
79:
80: begin
81:
82: p_slave_session_id := -1;

Line 183: where a.sid = ( select distinct b.sid from v$mystat b);

179: -- Don't use SESSIONID as invalid on standby!
180:
181: cursor c2 is select a.sid,a.serial#,a.audsid
182: from v$session a
183: where a.sid = ( select distinct b.sid from v$mystat b);
184:
185: l_valid number;
186: l_slave_session_id number;
187: l_sid number := -1;