If your system is configured for SELECT failover, a query being executed at the time of failover will be re-executed after the re-established connection with the cursor repositioned and return any remaining rows, thus providing seamless failover and a complete result set.
There are workarounds using callback functions to handle TAF limitations such as a reissue of your session variables after failover.
So, TAF is effective in re-establishing connections and completeing SELECT statements in the event of failure, but it's limitations need to be understood and accounted before implementing in a production environment.
Dig Deeper on Oracle database availability
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.