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';