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不创建临时段
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-968956/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002849
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
