Databases Reference
In-Depth Information
The results of these operations can be seen in the following screenshot:
There's more...
In the latter steps of the recipe, we have manually striped the objects. But if we have many
objects in our database, manual striping can be a nightmare. In such situations, consider
moving objects to different tablespaces or using partitions.
We can also distribute tables and related indexes on different disks, to obtain performance
gain in both read and write operations. If we have tables and indexes on the same disk, we
need to read and write in two different places on the same disk. By dividing the work between
two disks, we can perform an index range scan faster than when the index and the table are
on the same disk.
See also
F
The
Using partitioning
recipe in
Chapter 3
,
Optimizing Storage Structures
Choosing different RAID levels for different
Oracle files
In this recipe, we will see the characteristics of different RAID levels available in the market
and learn what to choose for each different Oracle file type.
RAID is the acronym for Redundant Arrays of Inexpensive Disks, a common configuration
in a storage subsystem. It is used to obtain low-cost, fault-tolerant configurations for high
performance in the non-mainframe market, by using multiple "inexpensive" disks in different
configurations.
