Difference between v$temp_space_header and v$sort_segment
来源:互联网 发布:centos 6 php7 编辑:程序博客网 时间:2024/06/05 00:21
参见下面三点:
第一点:
v$temp_space_header preserves data across database restarts whereas v$sort_segments and v$sort_usage are for current usage. You won't query v$temp_space_header for temp tablespace usage but only v$sort_usage and v$sort_segment.
第二点:
v$temp_space_header will show you those blocks which are touched from yours database started , it will show yours all block which you used after yours instance mounted , blocks in v$temp_space_header are the total number of "initialized" blocks in the tempfiles since yours database started.The blocks in v$sort_segment are the total number of allocated and usable blocks for the current instance.After restarting the database v$temp_space_header will remember everything while v$sort_segment will lost everything after restarting the database.
第三点:
如果查询v$temp_space_header的空闲空间为0,那么 it just means at some time it has been fully utilized. Once space is allocated to Temp it is not released - it will be just reused. This view just says that all the space available has been already allocated. The view does not tell you how much space is available for your session to use.
- Difference between v$temp_space_header and v$sort_segment
- Differences between System V and Posix semaphores
- The Differences Between BSD and System V Unix
- The difference between (()) and ().
- difference between "<" and "<<"
- v$session and v$process
- V$UNDOSTAT and V$ROLLSTAT
- V$UNDOSTAT and V$ROLLSTAT
- Difference Between typedef and #define
- Difference between PCDATA and CDATA
- Difference between CComPtr and CComQIPtr
- Difference between RVCT and GCCE
- Difference between RVCT and GCCE
- difference between slist and list.
- difference between stack and heap
- Difference between replace and translate
- Difference between PrintWriter and PrintStream
- difference between Cookie and Session
- lvs、nginx和haproxy比较
- Python入门--数据类型
- ReactNative基础---Style and Flex
- 数组扁平化
- 旋转图片之opencv
- Difference between v$temp_space_header and v$sort_segment
- 冒泡排序
- 证金汇金券商股暴动,指数在大涨,机构们这样看20170828
- 英文科技论文写作细节
- java多线程之Join
- 数组变树
- ./include/caffe/common.hpp:4:32: fatal error: boost/shared_ptr.hpp: 没有那个文件或目录
- net-tools 和 iproute2
- 使用OkHttpClient的GET方式