Tablespace
来源:互联网 发布:华沙保卫战 知乎 编辑:程序博客网 时间:2024/04/28 03:34
From Wikipedia, the free encyclopedia
http://en.wikipedia.org/wiki/Tablespace
A tablespace is a storage location where the actual data underlying database objects can be kept. It is the physical portion of the database used to allocate storage for all DBMS managed segments. A database segment is a database object which occupies physical space such as table data and indexes. Once created, a tablespace can be referred to by name when creating database segments.
Tablespaces specify only the database storage locations, not the logical database structure, or database schema.For instance, different objects in the same schema may have differentunderlying tablespaces. Similarly, a tablespace may service segmentsfor more than one schema.
By using tablespaces, an administrator can control the disk layoutof an installation. A common use of tablespaces is to optimizeperformance. For example, a heavily used index can be placed on a fast SCSI disk.On the other hand, a database table which contains archived data thatis rarely accessed could be stored on a less expensive but slower IDE disk.
While it is common for tablespaces to store their data in a filesystem file, some database management systemsallow tablespaces to be configured directly over operating systemdevice entries, called raw devices, providing better performance byavoiding the OS filesystem overheads.
Oracle stores data logically in tablespaces and physically in datafiles associated with the corresponding tablespace.
- tablespace
- Tablespace
- Tablespace
- Tablespace
- tablespace
- tablespace
- 管理tablespace
- TABLESPACE学习
- tablespace 参数
- Oracle TableSpace
- tablespace status
- UNDO Tablespace
- transport tablespace
- alter tablespace
- undo tablespace
- DataBase Tablespace
- temporary tablespace
- Oracle Tablespace
- 揭秘联想移动互联网产品战略
- 存储过程批量删除表
- C++调试堆
- 更新数据库Sequence,解决数据库恢复主键重复的错误
- 解决db2 backup pending状态
- Tablespace
- 《古相思曲》
- 职业心理测试
- CAN协议简介
- strcpy/strcat && strncpy/strncat && strlcpy/strlcat 总结
- DB2数据库完整性暂挂SQL0668N的错误及解决方法
- DB2不支持从源代码页 "1386" 到目标代码页 "1114" 的转换
- 如何查看存储过程源代码
- 把字符串转换成时间小脚本