Mapping the Oracle alert log is easy and once defined, all you have to do is
query it with standard SQL syntax:
create directory BDUMP as
‚/software/oracle/oracleBase/diag/rdbms/alkisrep/alkisrep/trace‘;
create table
alert_log ( msg varchar2(80) )
organization external (
type oracle_loader
default directory BDUMP
access parameters (
records delimited by newline
)
location(‚alrt_mysid.log‘)
)
reject limit 1000;
Now we can easily extract important Oracle alert log information without leaving SQL*Plus, something like this SQL:
select msg from alert_log where msg like ‚ORA-00600%‘;
ORA-00600: internal error code, arguments: [17034], [2940981512], [0],[],[],[],[],[]
ORA-00600: internal error code, arguments: [18095], [0xC0000000210D8BF8],[],[],[],[],[]
ORA-00600: internal error code, arguments: [4400], [48],[],[],[]
Quelle: Don Burleson Link