oracle数据库大文件表空间的使用？
这几天在跟朋友讨论oracle架构的时候，提到了oracle big file tablespace，好几个人建议不使用big file tablespace，原因主要有两个方面：大文件表空间只有一个数据文件，使用久了这个数据文件会非常大，一旦出现坏块，大文件恢复非常慢，而且备份与恢复也慢一个文件不利用分散I/o到多个...显示全部
查看其它 4 个回答Acdante的回答
关于big file tablespace的用处，Oracle官方文档上给了答复：如下：
！========================================！
Benefits of Bigfile Tablespaces
1.Bigfile tablespaces can significantly increase the storage capacity of an Oracle database. Smallfile tablespaces can contain up to 1024 files, but bigfile tablespaces contain only one file that can be 1024 times larger than a smallfile tablespace. The total tablespace capacity is the same for smallfile tablespaces and bigfile tablespaces. However, because there is limit of 64K datafiles for each database, a database can contain 1024 times more bigfile tablespaces than smallfile tablespaces, so bigfile tablespaces increase the total database capacity by 3 orders of magnitude. In other words, 8 exabytes is the maximum size of the Oracle database when bigfile tablespaces are used with the maximum block size (32 k).
2.Bigfile tablespaces simplify management of datafiles in ultra large databases by reducing the number of datafiles needed. You can also adjust parameters to reduce the SGA space required for datafile information and the size of the control file.
3.They simplify database management by providing datafile transparency.!===================================================!
简而言之就是方便管理，适用于大数据量的系统，但是不便于增加存储或者数据恢复等。
一般情况下，没有特别需求，不建议使用大表空间。每个表空间数据量100GB也不是非常大，如果需要进行优化，建议采用表分区的方式进行。