我的数据库版本:
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production
我的查询表空间使用率版本,查了n久后,最后出现那个快照错误:
SQL> select
2 a.tablespace_name "tablespace_name",
3 trunc(sum_mb/1024)+1 "sum_gb",
4 trunc((sum_mb-free_mb)/1024) "used_gb",
5 trunc(free_mb/1024) "free_gb",
6 (trunc((sum_mb-free_mb)/sum_mb,4)*100) "used_percent"
7 from
8 (select tablespace_name,sum(bytes)/1024/1024 sum_mb from dba_data_files group by tablespace_name) a,
9 (select tablespace_name,sum(bytes)/1024/1024 free_mb from dba_free_space group by tablespace_name) b
10 where a.tablespace_name=b.tablespace_name(+)
11 order by 5;
(select tablespace_name,sum(bytes)/1024/1024 sum_mb from dba_data_files group by tablespace_name) a,
*
第 8 行出现错误:
ORA-01555: 快照过旧: 回退段号 20 (名称为 "_SYSSMU20_1268957423$") 过小
但是我在有些11g用这个脚本查也很快,最多一分钟,10g,9i都可以查,怎么这个就不行了?