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'; 控制文件的名稱(chēng)及大小 select name,block_size*file_size_blks bytes from v$controlfile; 聯(lián)機(jī)重做日志文件的成員名稱(chēng)及大小 select member,bytes from v$log join v$logfile using (group#); 數(shù)據(jù)文件和臨時(shí)文件的名稱(chēng)及大小 select name,bytes from v$datafile union all select name,bytes from v$tempfile;
