TA的每日心情 | 郁闷 2022-8-11 23:40 |
---|
签到天数: 973 天 [LV.10]以坛为家III
七彩门番
 
- 积分
- 3867
|
发表于 2011-12-7 11:18:39
|
显示全部楼层
Using bigfile tablespaces with a block size of 32K, a datafile can be as large as 128 terabytes,
with a maximum database size of 8 exabytes (EB). In contrast, a database using only smallfile
tablespaces can have a maximum datafile size of 128 gigabytes (GB) and therefore a maximum
database size of 8 petabytes (PB). Because a bigfile tablespace can only have one datafile, you
never need to decide whether to add a datafile or autoextend the single datafile for the tablespace.
If you are using ASM and OMF, you won’t even need to know the name of the single datafile.
Given that the maximum number of datafiles in a database on most platforms is 65,533, and
the number of blocks in a bigfile tablespace datafile is 232, you can calculate the maximum amount
of space (M) in a single Oracle database as the maximum number of datafiles (D) multiplied by the
maximum number of blocks per datafile (F) multiplied by the tablespace block size (B):
M = D * F * B
谷歌翻译真好用 |
|