感谢楼上诸位兄弟,小结下,只说性能,管理上优势显而易见: 1. Bigfile在某些可能影响性能的方面做的比Smallfile Performance of database opens, checkpoints, and DBWR processes should improve if data is stored in bigfile tablespaces instead of traditional tablespaces. However, increasing the datafile size might increase time to restore a corrupted file or create a new datafile. -- http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/physical.htm#i14068 2. ASM可以改善性能,由上面天黑的回复及 ASM:A vertical integration of both the file system and the volume manager built specifically for Oracle Database files. It extends the concept of stripe and mirror everything to optimize performance, while removing the need for manual I/O tuning. -- http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/glossary.htm#CNCPT1995 3. 不过上面都是ORACLE自己说的,有时候也当不得真。 4. 所以有没有人明白里面的实现机理或给出测试数据。 5. 此帖200分,哪边给建议都给分,明天结帐,多谢!
BIGFILE似乎并行性不如SMALLFILE啊。
1. Bigfile在某些可能影响性能的方面做的比Smallfile
Performance of database opens, checkpoints, and DBWR processes should improve if data is stored in bigfile tablespaces instead of traditional tablespaces. However, increasing the datafile size might increase time to restore a corrupted file or create a new datafile.
-- http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/physical.htm#i14068
2. ASM可以改善性能,由上面天黑的回复及
ASM:A vertical integration of both the file system and the volume manager built specifically for Oracle Database files. It extends the concept of stripe and mirror everything to optimize performance, while removing the need for manual I/O tuning.
-- http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/glossary.htm#CNCPT1995
3. 不过上面都是ORACLE自己说的,有时候也当不得真。
4. 所以有没有人明白里面的实现机理或给出测试数据。
5. 此帖200分,哪边给建议都给分,明天结帐,多谢!