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; |