工作备忘录
-
编辑 删除
查看os的位数
redhat linux ：getconf WORD_BIT32[@more@]
-
编辑 删除
查看rman备份的大小和时间
查看rman备份数据文件量的sql，留此备忘。[@more@]比较某2天的数据文件的备份量select file#,recid,to_char(creation_time,'yyyymmdd hh24:mi:ss'),datafile_blocks,blocks,to_char(completion_time,'yyyymmdd hh24:mi:ss') from v$backup_datafile where trunc(completion_time)=to_date('20060126','yyyymmdd') or trunc(completion_time)=trunc(sysdate) order by file#,recid;查看某天 数据文件总的备份量select sum(blocks) from v$backup_datafile where trunc(completion_time)=to_date('20060126','yyyymmdd');
