v$session 视图中的 FAILOVER_TYPE 字段

如果我们的连接串中含有 FAILOVER_MODE 字段（图一），那么连上来的session 中FAILOVER_TYPE 的值为session （图二）

否则为NONE

NEWKFDB1 =  (DESCRIPTION =    (LOAD_BALANCE = OFF)    (FAILOVER = ON)    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = XXXXX)(PORT = 1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = 135.10.55.53)(PORT = 1521))    )    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = JYKFSERV)  (FAILOVER_MODE=(TYPE=SESSION)(METHOD=BASIC)(RETRIES = 4)(DELAY = 1))    )  ) 

图一

SQL> select FAILOVER_TYPE from v$session where USERNAME='HUANG';FAILOVER_TYPE---------------------------------------SESSION

图二


否则这个字段为空 ：none