GI version: 11.2.0.4
OS : Oracle Linux 6.5
Question1.
By default (without TAF), when an instance crashes, the queries are failed over to another node. So, what advantage does Transparent Application Failover bring ?
Below is what 11.2 documentation says
http://docs.oracle.com/cd/E11882_01/network.112/e10836/advcfg.htm#NETAG338
"TAF can operate in one of two modes, Session Failover and Select Failover. Session Failover re-creates lost connections and sessions. Select Failover replays queries that were in progress."
I assume the regular failover (without TAF configured) has only Session failover. Am I right ? Are there any other advantages for TAF ?
Question2.
The below doc says
http://docs.oracle.com/cd/E11882_01/java.112/e16548/ocitaf.htm#JJDBC28836
"Transparent Application Failover (TAF) is a feature of the Java Database Connectivity (JDBC) Oracle Call Interface (OCI) driver. "
The connection we make to the database using Development GUI tools like Toad, SQL Developer, Allround PL/SQL Developer use OCI driver. Right ?