5oracledatabase12c最大化應用程序的可用性-文庫吧資料
2025-03-07 03:21本頁面
【正文】 。 2023, Oracle and/or its affiliates. All rights reserved. 22 Solution Coverage Application Continuity for Java ? Client – JDBCThin driver – UCP, WebLogic Server ? Database – SQL, PL/SQL, RPC – Select, ALTER SESSION, DML, DDL, COMMIT/ROLLBACK/SAVEPOINT – Transaction models: Local, Parallel, Remote, Distributed – Mutable function support – Hardware acceleration on current Intel SPARC chips Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 20 Application Continuity In Action Call 1 Application Proxy 1 Proxy 2 RAC Database Instance1 Instance2 Instance3 Call 2 Connection Replay Context Oracle JDBC Driver Copyright 169。 2023, Oracle and/or its affiliates. All rights reserved. 18 Application Continuity Mask Database Outage When Successful ?Replays inflight work on recoverable errors ?Masks many hardware, software, work, storage errors and outages when successful ?Improves end user experience 5. Response 1. Work Request 2. DB Calls 12c ORACLE Database 4. Replay 3. Errors 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。 get Last LTXID new session Commit oute? COMMIT/ROLLBACK start transaction assign LTXID COMMIT? Return Preserve COMMIT OUTCOME Client/Midtier Database Time Recoverable Error COMMIT Get Logical TX ID SQL, PL/SQL, RPC Results TG in Action 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 L
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1