本文探讨了数据库中一种特殊的临时段管理方式：在排序结束后，这些临时段不会被立即释放，而是标记为自由空间并保留在表空间内以备重用。这种机制通过创建一个名为Sort Extent Pool (SEP)的元素来跟踪这些空间。
A temporary segment created in this tablespace will not be de-allocated
at the end of the sort. Instead the extents are MARKED as free, are not
placed back on the freelist, and are retained for reuse. An element called
the Sort Extent Pool (SEP) is created in the SGA to describe them.
at the end of the sort. Instead the extents are MARKED as free, are not
placed back on the freelist, and are retained for reuse. An element called
the Sort Extent Pool (SEP) is created in the SGA to describe them.
扫一扫
3542
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
