Shortly after the initial release of Oracle Database 11g, Oracle exposed additional
storage management capabilities in the database. These features are especially useful
in configuring storage for Oracles??™s Information Appliances, described in Chapter 8.
How Oracle I/O and Striped Arrays Interact
In almost all large databases, disk striping increases disk I/O rates without adding too
heavy an administrative burden for managing a large number of datafiles across many
individual disks. The disks may be organized into RAID arrays using a volume manager
on the database server, a dedicated I/O subsystem, or a combination of both.
If you are using an Oracle release without ASM, when you set up striped disk arrays,
youcan set the chunk size used to stripe across the disks. The chunk size is the
amount of data written to one disk before moving to the next disk in the array.
Understanding the interaction between different stripe chunk sizes and the two sizes
of Oracle I/O is critical in maximizing your I/O performance.
Consider an Oracle database with an 8 KB data block size and the DB_FILE_
MULTIBLOCK_READ_COUNT initialization parameter set to 32.
Pages:
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377