oracle12c
作者oracle12c·2013-07-13 12:39
数据库管理员·**证券

Table spaces and storage management

字数 2134阅读 2165评论 0赞 0

Table spaces can be set up in different ways, depending on how you want them to use available storage. You can have the operating system manage allocations of space, or you can have the database manager allocate space for your data, based on parameters you specify. Or you can create table spaces that allocate storage automatically.

The three types of table spaces are known as:
  • System managed space (SMS), in which the operating system's file manager controls the storage space once you have defined the location for storing database files
  • Database managed space (DMS), in which the database manager controls the usage of storage space one you have allocated storage containers.
  • Automatic storage table spaces, in which the database manager controls the creation of containers as needed.
Each can be used together in any combination within a database

如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!

0

添加新评论0 条评论

Ctrl+Enter 发表

作者其他文章

相关文章

相关问题

相关资料

X社区推广