-----检查flash recovery area的使用情况
select * from V$FLASH_RECOVERY_AREA_USAGE;FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 0 0 0
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
--计算flash recovery area已经占用的空间
SQL> select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;SUM(PERCENT_SPACE_USED)*3/100
-----------------------------
0
--------查看recovery_file_dest
select name,space_limit/1024/1024 as space_limit,space_used/1024/1024 as space_used from v$recovery_file_dest;NAME
--------------------------------------------------------------------------------SPACE_LIMIT SPACE_USED
----------- ----------
D:\oracle\product/flash_recovery_area
2048 0我想说的是 都是0 怎么就出现 ORA 00257。麻烦大家帮忙看下。谢啦。急本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/panys/archive/2009/01/20/3838846.aspx
select * from V$FLASH_RECOVERY_AREA_USAGE;FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 0 0 0
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
--计算flash recovery area已经占用的空间
SQL> select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;SUM(PERCENT_SPACE_USED)*3/100
-----------------------------
0
--------查看recovery_file_dest
select name,space_limit/1024/1024 as space_limit,space_used/1024/1024 as space_used from v$recovery_file_dest;NAME
--------------------------------------------------------------------------------SPACE_LIMIT SPACE_USED
----------- ----------
D:\oracle\product/flash_recovery_area
2048 0我想说的是 都是0 怎么就出现 ORA 00257。麻烦大家帮忙看下。谢啦。急本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/panys/archive/2009/01/20/3838846.aspx
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货