Databases Reference
In-Depth Information
• Multi-Threaded Server (MTS), now known as shared server
• Shared SQL
• Stored procedures and triggers
• XA support
• Distributed transactions and two-phase commits
• Data replication
• Oracle Parallel Server (OPS)
1
Oracle8 enhanced existing functionality and introduced additional OLTP-related fea‐
tures, including the following:
• Connection pooling
• Connection multiplexing
• Data partitioning
• Advanced Queuing (AQ)
• Index organized tables
• Internalization of the Distributed Lock Manager (DLM) for Oracle Parallel Server
• Internalization of the triggers for replicated tables and parallel propagation of re‐
plicated transactions
Oracle8
i
provided the following additional enhancements and technologies for OLTP:
• Support for Java internally in the database kernel
• Support for distributed component technologies: CORBA v2.0 and Enterprise
JavaBeans (EJB) v1.0
• Publish/subscribe messaging based on Advanced Queuing
• Online index rebuild and reorganization
• Database Resource Manager (DBRM)
• Use of a standby database for queries
• Internalization of the replication packages used to apply transactions at the remote
sites
Oracle9
i
continued this trend, with the introduction of Real Application Clusters, which
extended the benefits of Oracle Parallel Server to OLTP applications. Since Oracle
1. OPS was actually available for DEC VMS in 1989 and for NCR Unix with the last production release of Oracle6
(version 6.0.36), but it became widely available, more stable, and more popular in Oracle7.
