Windows NT Maximum 4Gb files on FAT
Theoretical 16Tb on NTFS
Sun Solaris (32 bit Oracle releases)
===========================================================================
OS Limits
~~~~~~~~~
Release Max file-system size Max OS File size
< Solaris 2.6 1Tb (UFS) 2Gb
>= Solaris 2.6 1Tb (40 bits) 1Tb
HP
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
HPUX Unix Limits
~~~~~~~~~~~~~~~~~
Max file system size:
<= HP-UX 10.10 4Gb
>= HP-UX 10.20 128Gb
>= HP-UX 11.00 1Tb
Max OS file size:
<= HP-UX 10.10 2Gb
>= HP-UX 10.20 128Gb
>= HP-UX 11.00 1Tb
Oracle on HPUX Limits
~~~~~~~~~~~~~~~~~~~~~~
Max Datafile Size
File Raw Async Export/ SQL*Loader
Release System Device I/O Import** (see **)
===========================================================================
8.1.7.x 64Gb 64Gb raw only >2Gb >2Gb
8.1.6.x 64Gb 64Gb raw only >2Gb >2Gb
8.0.6.x 64Gb 64Gb raw only See*1 See*2
8.0.5.x 64Gb 64Gb raw only See*1 <2Gb
8.0.4.x 64Gb 64Gb raw only SIL HPUX10.20 > 2Gb
HPUX-11 <2Gb
8.0.3.x <2Gb <2Gb raw only 2Gb 2Gb
7.3.4.x 64Gb 64Gb raw only SIL 2Gb
>=7.3.3.4.1 64Gb 64Gb raw only SIL 2Gb
7.3.2.3 <2Gb <2Gb raw only 2Gb 2Gb
7.1.6 <2Gb <2Gb raw only 2Gb 2Gb
下面的SQL语句可以查看数据库物理文件是否是自动增长的及相关参数.
select tablespace_name,file_name,round(bytes/(1024*1024),0) total_space,
autoextentsible,increment_by,maxbytes from dba_data_files order by tablespace_name;