從11g開始…AlertLog開始變成了XML的格式,目的是方便其他軟體來分析LOG File…
for 10G
$oracle_home\admin\SID\bdump\alert.log
for 11G
SQL> select value from v$diag_info where name =’Diag Alert’;
VALUE
——————————————————————————–
/opt/oracle/diag/rdbms/orcl/orcl/alert
SQL> select value from v$diag_info where name =’Diag Alert’;
VALUE
——————————————————————————–
/opt/oracle/diag/rdbms/orcl/orcl/alert
SQL> select value from v$diag_info where name =’Diag Trace’;
VALUE
——————————————————————————–
/opt/oracle/diag/rdbms/orcl/orcl/trace
