Database - RAC/Scalability (MOSC)

MOSC Banner

failover_mode is no but failover_method is yes in v$session

edited May 3, 2014 1:17PM in Database - RAC/Scalability (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center