5oracledatabase12c最大化應(yīng)用程序的可用性-wenkub
2023-03-22 03:21:58 本頁面
【正文】 ion Guard, retry can cause logical corruption ?Used by Application Continuity ?Can be used independently of Application Continuity 4. Enforce Oute 1. Work Request 2. DB Calls 12c ORACLE Database 3. Errors 4. Reliable Commit Oute Copyright 169。 ? PreparedStatement pstmt = … – … – SQL, PL/SQL, local calls, RPC – … ? ()。 2023, Oracle and/or its affiliates. All rights reserved. 8 Program Agenda ? Problems to Solve ?New Concepts ? Transaction Guard ? Application Continuity ? Application Design Considerations Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 4 My Next Session ? Oracle InDatabase MapReduce: When Hadoop Meets Exadata – 7/25/13, 12:00– 13:00, Room 431 Copyright 169。Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 5 Program Agenda ?Problems to Solve ? New Concepts ? Transaction Guard ? Application Continuity ? Application Design Considerations Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 9 Recoverable Error ? Formalized property ? Applications No longer need to maintain own list of error codes (., ora1033, ora1034, oraxxx) ? JDBC throws SQLRecoverableException Copyright 169。 ? ()。 2023, Oracle and/or its affiliates. All rights reserved. 13 Transaction Guard – Typical Usage Upon database instance crash ? FAN aborts dead session ? Application gets an error ? Pool removes orphan connection from pool ? If “recoverable error” then Get last LTXID from dead session Obtain new database session Get transaction status Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 16 Transaction Guard in Oracle database 12c ? JDBCthin, , OCI, OCCI ? Commit Models ? Local TXN ? Automit, Commit on Success ? Commit embedded in PL/SQL ? DDL, DCL, Parallel DDL ? Remote, Distributed ? Exclusions ? XA ? R/W DBLinks from Active Data Guard or Rea
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1