Oracle then
tunes memory for optimal SGA and PGA performance on an ongoing basis.
TimesTen
In 2005, Oracle acquired the leading in-memory database TimesTen. In-memory
databases provide optimal performance by reducing data retrieval latency. The optimizer
used with the TimesTen database is aware of the memory location of the data,
and creates execution plans to take advantage of this residency. In addition, the
actual number of machine instructions is significantly reduced, since there is no need
for code to handle situations where data resides only on disk. TimesTen is most
appropriate for a high-load OLTP environment that requires extremely high throughput
and real-time responsiveness.
A TimesTen instance can be used as a cache for an Oracle database. You load a subset
of Oracle tables into the TimesTen instance, and the Cache Connect to Oracle
feature keeps the data synchronized.
Youcan also enable replication between TimesTen instances on different machines
for load sharing and higher availability. For more information on TimesTen, please
refer to the relevant pages on the Oracle Technology Network.
Pages:
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406