应用升级的时候,用oem控制台看temp表空间已经满了。但是toad图形显示used为0%。

跑完下面的脚本让我更加相信toad啦~

[@more@]

The following are a few queries 
that can be used to list more meaningful information about the temporary segment usage:

This will give the "high water mark" of that temporary tablespace (= max used at one time):

select tablespace_name, sum(bytes_cached)/1024/1024 mb
from v$temp_extent_pool
group by tablespace_name;

This will give current usage:

select ss.tablespace_name,
sum((ss.used_blocks*ts.blocksize))/1024/1024 mb
from gv$sort_segment ss, sys.ts$ ts
where ss.tablespace_name = ts.name
group by ss.tablespace_name;

ITPub博客

tem表空间使用情况查询脚本

最新文章