使用sql查看alert日志概要1.docVIP

select value from v$diag_info where name =Diag Trace; /app/oracle/diag/rdbms/db2/DB2/trace/alert_DB2.log /104152/viewspace-139982/ 上周去巡检.结果一个用户问我如何使用sql语句来查看alert日志中的内容. 当时想着用存储过程来做.回来后想了想,用external测试一下看看: SQL !pwd/u01/app/oracle/admin/ORALINUX/bdump create directory BDUMP as /u01/app/oracle/admin/ORALINUX/bdump; SQL !lsALERT_LOG_3220.bad alert_ORALINUX.log oralinux_lgwr_3202.trc oralinux_lgwr_7056.trcALERT_LOG_3220.log oralinux_lgwr_3123.trc oralinux_lgwr_6993.trc oralinux_pmon_7048.trc create table alert_log ( text varchar2(80) )organization external (type oracle_loaderdefault directo