Oracle Alert Log checking through SQL Plus

Oracle 9i Onwards we could track alert log file viz alert_<sid>.log file via sqlplus

as it supports the feature of reading flat files.

First we create a directory bdump and map it to the bdump directory;

create directory alertlogdir as '~/path/to/dump/direcotry';

create table Alert_log(msg varchar2(100))

oraganization external(type oracle_loader default directory alerlogdir access parameters(

records delimited by newline)

location('alert_<sid>.log');

sqlplus>select * from alert_log;