请各位高手帮忙解决下:怎么用PLSQL Developer工具来查看Oracle10g数据库中表空间和临时表的?
解决方案 »
- oracle9i客户端访问11g错误日志,请高手看是什么原因?
- 物化视图(Materialize View)与一般视图(View)有何区别
- 奇怪的Group by问题
- 这个问题似乎特殊了点,求大家帮我解决!
- 如何使用odi对没有主键的表进行数据抽取
- 菜鸟 求教2个小问题(关于SQL搜索语句)!
- Oracle中如何查看SQL语法方面的资料,比如说函数的用法等。
- Oracle是否可以在客户端不安装其他的任何软件就可以访问?如果可以如何书写主机和服务名。
- oracle enterprise manager console登陆问题???
- 创建带参数过程的job ,请高手帮忙
- 求助在这种表结构下如何写出Sql语句进行汇总统计,希望高手指点。
- 查询语句错误 ORACLE 10g 各位帮忙解答
临时表直接看还真不知道,一般都是用语句。select * from user_Tables where temporary='Y'
select a.name,
a.Gbytes as total,
(a.Gbytes - nvl(b.Gbytes, 0)) as usage,
nvl(b.Gbytes, 0) as free,
round((((a.Gbytes - nvl(b.Gbytes, 0)) / a.Gbytes) * 100), 2) || '%' as usagep
from (select tablespace_name as name, round(sum(bytes) / 1024 / 1024 / 1024, 3) as Gbytes
from dba_data_files
group by tablespace_name) a,
(select tablespace_name as name, round(sum(bytes) / 1024 / 1024 / 1024, 3) as Gbytes
from dba_free_space
group by tablespace_name) b
where a.name = b.name(+);--临时表空间
select a.name,
a.Gbytes as total,
(a.Gbytes - nvl(b.Gbytes, 0)) as usage,
nvl(b.Gbytes, 0) as free,
round((((a.Gbytes - nvl(b.Gbytes, 0)) / a.Gbytes) * 100), 2) || '%' as usagep
from (select tablespace_name as name, round(sum(bytes) / 1024 / 1024 / 1024, 3) as Gbytes
from dba_temp_files
group by tablespace_name) a,
(select tablespace_name as name, round(sum(free_space) / 1024 / 1024 / 1024, 3) as Gbytes
from dba_temp_free_space
group by tablespace_name) b
where a.name = b.name(+);
临时表一般是在运行时生成的,语句执行完成就释放。所以一般是看不到的