Oracle 中的表空间 [英] Tablespaces in Oracle

问题描述

向数据库添加表空间是否会降低 Oracle 9 数据库的性能?我们认为请求的数量保持不变.

Is adding tablespaces to a database decrease the performance of an Oracle 9 database? We consider that the number of request remains constant.

谢谢，

埃里克

推荐答案

不，表空间允许您在逻辑上分离对象，添加更多没有区别 - 您在相同数量的磁盘上存储了相同数量的数据.

No, tablespaces allow you to logically separate objects, and adding more makes no difference - you have the same amount of data stored on the same amount of disk.

如何跨表空间组织表和索引会产生影响；特别是在不同的表空间中为其表创建索引，尽管这实际上与底层数据文件以及这些文件在磁盘上的组织方式有关.(我认为，随着磁盘技术的改进以及 SAN/NAS 的广泛使用，这是否会产生更大的差异还存在一些争论.)

How tables and indexes are organised across tablespaces can make a difference; particularly having indexes in different tablespaces to their tables, though that's really to do with the underlying data files and how those are organised on disk. (I think there's some debate about whether even that makes much difference any more, as disk technology has improved, and with the widespread use of SAN/NAS.)

这篇关于Oracle 中的表空间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！