“Opinions expressed are solely my own and do not express the views or opinions of my employer.” Some database administrators have a hard time finding the alert log file in systems that they are not familiar with. Therefore, I decided to share two simple techniques to find the alert log file regardless of whether you know the system. Thus, the first technique is to check the alert log being connected to the SQL prompt using the x$dbgalertext view that brings the current information of the alert log. Therefore, this SQL…