Users submitting tuned queries for specific business
functions are a key part of OLTP. Ad hoc queries across broad data sets are not.
Oracle??™s OLTP Heritage | 205
Business intelligence data warehousing systems and OLTP systems could access
much of the same data, but these types of systems also typically have different
requirements in terms of CPU, memory, and data layout, which makes supporting a
mixed workload less than optimal for both types of processing. Real Application
Clusters, with dynamic service provisioning since Oracle Database 10g, makes it possible
to allocate individual nodes for individual workloads. It also makes it more
feasible to deploy these mixed workloads to a single database (albeit with multiple
database instances).
Oracle??™s OLTP Heritage
Oracle has enjoyed tremendous growth as the database of choice for OLTP in the
midrange-computing environment. Oracle6 introduced nonescalating row-level locking
and read consistency (two of the most important of Oracle??™s core OLTP
features), but Oracle7 was really the enabler for Oracle??™s growth in OLTP.
Pages:
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457