http://oracle-help.com/oracle-database/read-alert-log-from-xdbgalertext-in-oracle/
Read Alert log from x$dbgalertext in Oracle