ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 9i到10g sort segment的变化

9i到10g sort segment的变化

原创 Linux操作系统 作者:ylw66 时间:2009-12-01 09:22:44 0 删除 编辑

concepts中关于sort segment的描述有这么一段是变化的:
9iYou can manage space for sort operations more efficiently by designating

temporary tablespaces exclusively for sorts. Doing so effectively eliminates

serialization of space management operations involved in the allocation and

deallocation of sort space.

 

A temporary tablespace can be used only for sort segments. A temporary tablespace

is not the same as a tablespace that a user designates for temporary segments,

which can be any tablespace available to the user. No permanent schema objects can

reside in a temporary tablespace

 

 

10gYou can manage space for sort operations more efficiently by designating one or more

temporary tablespaces exclusively for sorts. Doing so effectively eliminates

serialization of space management operations involved in the allocation and

deallocation of sort space. A single SQL operation can use more than one temporary

tablespace for sorting. For example, you can create indexes on very large tables, and

the sort operation during index creation can be distributed across multiple tablespaces.

 

One or more temporary tablespaces can be used only for sort segments. A temporary

tablespace is not the same as a tablespace that a user designates for temporary

segments, which can be any tablespace available to the user. No permanent schema

objects can reside in a temporary tablespace.

 

从描述变化可以看出9i sort segments只使用1个表空间,但10g中可能使用1个或多个表空间

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22111412/viewspace-621057/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-07-29

  • 博文量
    57
  • 访问量
    94745