Database - RAC/Scalability (MOSC)

MOSC Banner

fail over type - transaction vs select ? looks the same

edited Sep 12, 2018 5:01AM in Database - RAC/Scalability (MOSC) 5 commentsAnswered

hi guys,

just need to understand abit more on what is the different between the failover type of the TAF when one specify TRANSACTION or SELECT.

I see no difference from the abstract:

Currently, TAF will fail over standard SQL SELECT statements that have been caught during a node crash in an in-flight transaction failure. In the current release of TAF, however, TAF must restart some types of transactions from the beginning of the transaction.

The following types of transactions do not automatically fail over and must be restarted by TAF:

Transactional statements. Transactions involving INSERT, UPDATE, or DELETE statements are not supported by TAF.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center