oracle 常用查询
1. 查看数据库状态
?? select v.INSTANCE_NUMBER,v.INSTANCE_NAME,v.STATUS from v$instance v;
2. 查看归档日志占用磁盘空间大小
?? select? name,space_limit as quota,space_used as used,
? space_reclaimable as reclaimable,number_of_files as files from v$recovery_file_dest；
3. 删除过期归档日志
??? C:>rman
???? rman>connect target
???? rman> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-30';
????
?
