Alert Log for 11G

從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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.