Books for you

Oracle??™s concurrency handling could avoid an enormous amount of
contention and performance degradation in a heavy use scenario??”in fact, the greater
the workload, the greater the benefits of MVRC.
Concurrent Access and Performance | 197
Concurrent Access and Performance
When youread through all the steps involved in the above processes, youmight
think that Oracle would be a very slow database. This is not at all true. Oracle has
consistently turned in benchmarks that make it one of the fastest databases, if not
the fastest, on the market today.
Oracle provides good performance while implementing multiversion read consistency
by minimizing and deferring unnecessary I/O operations. To assure the
integrity of the data in a database, the database must be able to recover in the event
of a system failure. This means that there must be a way to ensure that the data in
the database accurately reflects the state of the committed data at the time of the
crash. Oracle can do this by writing changed data to the database whenever a transaction
commits.


Pages:
416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440