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)

sqlplus>select * from alert_log;