Books for you

OMFs reduce the maintenance overhead of naming
and tracking the filenames for your database, as well as avoiding the problems
that can result from human errors in performing these tasks. Since Oracle Database
10g, OMFs and bigfile tablespaces combine to make datafiles appear completely
transparent.
Oracle databases can be deployed on up to 64,000 datafiles. Because a bigfile
tablespace can contain a file that is 1,024 times larger than a smallfile tablespace, and
bigfile tablespaces have 32 KB block sizes on 64-bit operating systems, the Oracle
database can grow to up to 8 exabytes in size (an exabyte is equivalent to a million
terabytes).* The bigfile tablespace is designed for use with Oracle??™s Automatic Storage
Management (ASM), other logical volume managers that support striping, and
RAID.?? 
Figure 2-2. Tablespaces and datafiles
* The ultimate size of a bigfile depends on the limitations of the underlying operating system.
??  RAID stands for ???redundant array of inexpensive disks??? and is described in Chapter 7.


Pages:
85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109