V$FS_FAILOVER_OBSERVERS

7.230 V$FS_FAILOVER_OBSERVERS

V$FS_FAILOVER_OBSERVERS provides information about fast-start failover observers.

If you are querying on the primary database, this view returns three rows, each describing one observer. However, only a row having an non-empty value in column NAME corresponds to a started observer. If you are querying on a non-primary database, the behavior of this view is not defined.

Column	Datatype	Description
`NAME`	`VARCHAR2(513)`	The fast-start failover observer name
`REGISTERED`	`VARCHAR2(4)`	Indicates if this observer is registered (`YES`) or not (`NO`). Note that the observer is registered only if `HOST` is not `NULL`.
`HOST`	`VARCHAR2(513)`	The name of the host where this observer is running
`ISMASTER`	`VARCHAR2(4)`	Indicates if this observer is the master observer (`YES`) or not (`NO`)
`TIME_SELECTED`	`TIMESTAMP(9)`	Shows when this observer became master observer, if `ISMASTER` is `YES`; otherwise the following constant appears: `1990–01–01 00:00:00.00`
`PINGING_PRIMARY`	`VARCHAR2(4)`	Possible values: `YES`: Observer is currently connected to the primary database `NO`: Observer is not connected to the primary database Note: This field is consistent throughout an Oracle Real Application Clusters (Oracle RAC) environment; that is, if the observer is connected to any instance of the primary database in the Oracle RAC environment, all instances will show a value of `YES`.
`PINGING_TARGET`	`VARCHAR2(4)`	Possible values: `YES`: Observer is currently connected to the target standby database `NO`: Observer is not connected to the target standby database Note: This field is consistent throughout an Oracle Real Application Clusters (Oracle RAC) environment; that is, if the observer is connected to any instance of the target standby database in the Oracle RAC environment, all instances will show a value of `YES`.
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data