如题：
使用dba_data_file和dba_free_space 联合查询，看不到临时表空间temp了！
看不到?没有遇到过,是你查询语句不对吧.....攒经验,学习中,期待解决...
SQL code:
select t1."Tablespace" "Tablespace",
t1."Total (G)" "Total (G)",
nvl(t2."Used (G)", 0) "Used(G)",
t1."Total (G)" - nvl(t2."Used (G)", 0) "Free (G)"
from
(
select tablespace_name "Tablespace", to_char((sum(bytes/1024/1024/1024)),'99,999,990.900') "Total (G)"
from dba_temp_files
group by tablespace_name
union
select tablespace_name "Tablespace", to_char((sum(bytes/1024/1024/1024)),'99,999,990.900') "Total (G)"
from dba_data_files
where tablespace_name like'TEMP%'
group by tablespace_name
) t1,
(
select tablespace, round(sum(blocks)*8/1024) "Used (G)" from v$sort_usage
group by tablespace
) t2
where t1."Tablespace"=t2.tablespace(+)
结果:
Tablespace Total (G) Used(G) Free (G)
TEMP 0.039 0 0.039
能把查询语法贴出来看看吗？如果temp空间如果不够,有可能你的磁盘空间就不够了.这时候可能要检查硬盘空间是不是被占满了.
或者新建一个临时表空间,分配2G的空间,如果可以建立,就是你的临时表空间被占满了.
检查表空
