alert_SID.logOracle 10g 告警日志路径：cd $ORACLE_BASE/admin/SID/bdumpORACLE 11g 告警日志路径：cd $ORACLE_BASE/diag/rdbms/ocp11g/ocp11g/trace查看告警日志路径：select value from v$parameter where name='background_dump_dest'; 控制文件的名称及大小 select name,block_size*file_size_blks bytes from v$controlfile; 联机重做日志文件的成员名称及大小 select member,bytes from v$log join v$logfile using (group#); 数据文件和临时文件的名称及大小 select name,bytes from v$datafile union all select name,bytes from v$tempfile;
