Books for you

Oracle and Parallelism
The ability to parallelize operations is one of the most important features of the Very
Large Database (VLDB). Database servers with multiple CPUs, which are called
symmetric multiprocessing (SMP) machines, are the norm today for most database
servers, and the ability to perform operations in parallel also works well with multicore
CPU chips. As performance demands increase and data volumes continue to
grow, you will increasingly need to use multiple processors, cores and disks to reduce
* It??™s difficult to say exactly what will occur due to the alignment of the stripe-chunk boundaries with Oracle
data blocks, but to illustrate the single versusmultiple disk point, let??™s assume the simple case??”they line up!
For a more detailed discussion of striping issues, see the document ???Configuring Oracle Server for VLDB,???
by Cary Millsap, formerly of Oracle Corporation and now with Hotsos (see Appendix B). Anyone who is
tempted is welcome to perform detailed testing for all the permutations of stripe chunk size and Oracle I/O.


Pages:
355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379