5oracledatabase12c最大化應(yīng)用程序的可用性(專(zhuān)業(yè)版)
【正文】 2023, Oracle and/or its affiliates. All rights reserved. 29 GRANT [KEEP DATE TIME | KEEP SYSGUID].. [to USER] REVOKE [KEEP DATE TIME | KEEP SYSGUID][from USER] GRANT KEEP SEQUENCE.. [to USER] on [sequence object]。 2023, Oracle and/or its affiliates. All rights reserved. 14 Transaction Guard In Action getConnection() ()。 2023, Oracle and/or its affiliates. All rights reserved. 1 Maximum Application Availability with Oracle Database 12c Kuassi Mensah Director Product Management Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 11 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. 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 classes with Java interfaces Side Effects Use disable API if a database request has an external call that should not be replayed Callbacks Ensure a callback is registered if state changes outside any request (WLS/UCP labeling included by default) Mutable Functions Grant keeping mutable values if these are patible with your application Copyright 169。 CREATE SEQUENCE.. [sequence object] [KEEP|NOKEEP]。 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. 5 Program Agenda ?Problems to Solve ? New Concepts ? Transaction Guard ? Application Continuity ? Application Design Considerations Copyright 169。 ? PreparedStatement pstmt = … – … – SQL, PL/SQ
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1