Reading alert log via SQL

Sometimes is useful to put the result into a variable and wrap up some plsql code around it:

select message_text from X$DBGALERTEXT where rownum <= 20;

Leave a Reply

%d bloggers like this: