问一下在linux x64 下oracle11gr2 单个数据文件最大支持多少容量

redcat_cn

问一下在linux x64 下oracle11gr2 单个数据文件最大支持多少容量

Maclean Liu(刘相兵

Oracle 11g中数据库能有多大？
http://www.askmaclean.com/archiv ... A4%A7%EF%BC%9F.html

Database file size        Maximum        Operating system dependent. Limited by maximum operating system file size; typically 222 or 4 MB blocks

Bigfile Tablespaces        Number of blocks        A bigfile tablespace contains only one datafile or tempfile, which can contain up to approximately 4 billion ( 232 ) blocks. The maximum size of the single datafile or tempfile is 128 terabytes (TB) for a tablespace with 32 K blocks and 32 TB for a tablespace with 8 K blocks.


smallfile tablespace datafile    32k   128g
bigfile tablespace datafile     32k   128T