Oracle7
introduced many key features, including the following:
??? 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)*
Oracle8 enhanced existing functionality and introduced additional OLTP-related features
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
replicated transactions
* 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.
206 | Chapter 9: Oracle and Transaction Processing
Oracle8i provided the following additional enhancements and technologies for
OLTP:
??? Support for Java internally in the database kernel
??? Support for distributed component technologies: CORBA V2.
Pages:
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458