failover_mode is no but failover_method is yes in v$session
select sid,failover_type,failover_method,failed_over from v$session where failover_type='SELECT';
SID FAILOVER_TYPE FAILOVER_METHOD FAILED_OV
---------- --------------------------------------- ------------------------------ ---------
13 SELECT BASIC NO
54 SELECT BASIC NO
83 SELECT BASIC NO
181 SELECT BASIC NO
431 SELECT BASIC NO
Please advise if failed_over=no then why select failover type is coming in v$session
Best regards,
Vishal