【正文】
2023, Oracle and/or its affiliates. All rights reserved. 32 Copyright 169。 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。 CREATE SEQUENCE.. [sequence object] [KEEP|NOKEEP]。 REVOKE KEEP SEQUENCE [from USER] on [sequence object]。 2023, Oracle and/or its affiliates. All rights reserved. 28 ? Configure JDBC Replay Driver – Set replay data source in property file datasource= ? Enable Application Continuity on Service – Set FAILOVER_TYPE = TRANSACTION – Review settings for: REPLAY_INITIATION_TIMEOUT = 1800 FAILOVER_DELAY = 3 seconds FAILOVER_RETRIES = 60 retries SESSION_STATE_CONSISTENCY = DYNAMIC COMMIT_OUTCOME = TRUE Configuration 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。 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