Extents in Temporary Segments (21)

When Oracle completes the execution of a statement requiring a temporary segment,
Oracle automatically drops the temporary segment and returns the extents allocated
for that segment to the associated tablespace. A single sort allocates its own temporary
segment in a temporary tablespace of the user issuing the statement and then returns
the extents to the tablespaces.
Multiple sorts, however, can use sort segments in temporary tablespaces designated
exclusively for sorts. These sort segments are allocated only once for the instance, and
they are not returned after the sort, but remain available for other multiple sorts.
A temporary segment in a temporary table contains data for multiple statements of a
single transaction or session. Oracle drops the temporary segment at the end of the
transaction or session, returning the extents allocated for that segment to the
associated tablespace.

1. 当一条语句结束执行时 , 其所要求的临时段 , Oracle将删除并且返回其对应的表空间
2. Multiple sorts , 可以共享模式使用sort segments , 这些sort segments只在实例中
分配一次 , 排序结束后 , 他们仍然为其他Multiple sorts保存 , 而不返回给其对应的表空间.
3. 对于temporary table , 临时段会在当一个事务或者会话结束时 , Oracle才返回给其对应的表空间.

这段没有看得太明白.

[@more@]

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

转载于:http://blog.itpub.net/10599713/viewspace-968511/