5oracledatabase12c最大化應(yīng)用程序的可用性(完整版)
【正文】 2592023) Transaction Guard Configuration Copyright 169。 ? PreparedStatement pstmt = … – … – SQL, PL/SQL, local calls, RPC – … ? ()。 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。 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. 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 Read Only Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 24 Restrictions When Does Replay Not Occur? Normal Runtime Reconnect Replay Any call in same request after ? successful mit in dynamic mode (default) ? a restricted call ? disableReplay API ? Error is not recoverable ? Reconnection failure – Replay initiation timeout – Max connection retries – Max retries per incident ? Target database not valid for replay ? Last call mitted in dynamic mode ?Validation detects different results Copyright 169。 CREATE SEQUENCE.. [sequence object] [KEEP|NOKEEP]。 2023, Oracle and/or its affiliates. All rights reserved. 30 Maximum Application Availability with Oracle database 12c ?Hang ?Errors Connection Handling ?Oute of InFlight Work ?Resubmission of InFlight Work Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 26 Application Assessment Decide What to do Request Boundaries Mark Request Boundaries, if you are not using Oracle Pools JDBC Concrete Classes Replace deprecated concrete class
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1