Benefit / Impact:
Higher application availability
Application availability problems in case of failed nodes or database instances
Action / Repair:
Application connection failover and load balancing is highly recommended for OLTP environments but may not apply for DSS workloads. DSS application customers may want to ignore this warning.
The following query will identify the application user sessions that do not have basic connection failover configured:
select username, sid, serial#,process,failover_type,failover_method FROM gv$session where upper(failover_method) != 'BASIC' and upper(failover_type) !='SELECT' and upper(username) not in ('SYS','SYSTEM','SYSMAN','DBSNMP');