ITPub博客

首页 > 应用开发 > IT综合 > Introduction to Temporary Segments (25)

Introduction to Temporary Segments (25)

原创 IT综合 作者:tsinglee 时间:2007-09-11 15:21:40 0 删除 编辑

When processing queries, Oracle often requires temporary workspace for intermediate
stages of SQL statement parsing and execution. Oracle automatically allocates this disk
space called a temporary segment. Typically, Oracle requires a temporary segment as a
database area for sorting. Oracle does not create a segment if the sorting operation can
be done in memory or if Oracle finds some other way to perform the operation using
indexes.

1. 临时段经常用做SQL解析和执行
2. 典型的情况是临时段用做排序
3. 如果Oracle排序能在内存中完成或者找到利用索引来优化操作的方法 , Oracle不创建临时段

[@more@]

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

上一篇: ORA-12638
请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1892116