DBORCLOUD Blog

2 PHASE COMMIT OVERVIEW

Two-phase commit protocol is comprised of a set of actions that ensure a transaction involving multiple databases does not produce unsynchronized updates. Two-phase commit provides a way for a series of database interactions on multiple different data sources to be grouped together and completed or rolled back as a single transaction. Two-phase commit transactions that represent a series of database interactions on multiple data sources are referred to as global transactions. At the beginning of a global transaction, a global transaction ID (XID) is generated and used by an external transaction manager to drive the two-phase commit processing across all Read More

2 PHASE COMMIT OVERVIEW

Two-phase commit protocol is comprised of a set of actions that ensure a transaction involving multiple databases does not produce unsynchronized updates. Two-phase commit provides a way for a series of database interactions on multiple different data sources to be grouped together and completed or rolled back as a single transaction. Two-phase commit transactions that represent a series of database interactions on multiple data sources are referred to as global transactions. At the beginning of a global transaction, a global transaction ID (XID) is generated and used by an external transaction manager to drive the two-phase commit processing across all Read More

RANGE-PARTITIONED TABLES

This topic contains RANGE-PARTITIONED TABLES that is available since Oracle 8i. 1. RANGE-PARTITIONED TABLES The PARTITION BY RANGE clause of the CREATE TABLE statement specifies that the table or index is to be range-partitioned. The PARTITION clauses identify the individual partition ranges, and the optional sub clauses of a PARTITION clause can specify physical and other attributes specific to a partition segment. Using Reference Partitioning: Range partitioning is useful when you have distinct ranges of data you want to store together. The classic example of this is the use of dates. Here an example: Creates a table of four partitions, Read More

HASH-PARTITIONED TABLES

The PARTITION BY HASH clause of the CREATE TABLE statement identifies that the table is to be hash- partitioned. The PARTITIONS clause can then be used to specify the number of partitions to create, and optionally, the tablespaces to store them in. Alternatively, you can use PARTITION clauses to name the individual partitions and their tablespaces. The only attribute you can specify for hash partitions is TABLESPACE. All of the hash partitions of a table must share the same segment attributes (except TABLESPACE), which are inherited from the table level. Using Reference Partitioning: Hash partitioning is useful when there is Read More

Oracle VM 3.4.3

In recent weeks Oracle has released VM 3.4.3 The principal enhancements present in this release are: Installation and Upgrades: – Simplified UEFI PXE Boot for Oracle VM Server Infrastructure: – Support for Software RAID Devices with Oracle VM Server – Support for Microsoft Windows Server Failover Clustering – Update to Oracle VM Agent for SPARC – Update to the dom0 Kernel – Updates to Multipath Configuration for Oracle ZFS Storage Appliance Performance and Scalability: – Improved Job completion performance – Improved Storage refresh performance – Improved Performance With Multiple Concurrent Connections to the Oracle VM Manager Command Line Interface Usability: Read More

Calling an ODI Scenario from APEX

How to call scenario odi from apex application. Instead to open the client to execute the run of the scenario there is possibility to call odi scenario just using a button created into your application front-end apex. Objects to create – Job type PLSQL_BLOCK – Apex button to enable the job indicated Here the source for the button As we developed the following Download the script that contains: – create job – enable the job created Out of scope: – Create scenario propaedeutic for the job, in this case the scenario calls PKG_ALLINEA_CASSE (see ScenarioName tag)