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;
