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;