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 Comment

Your email address will not be published. Required fields are marked *