CODE EXAMPLE FOR SQL

oracle alert log location

SQL> select value from v$diag_info where name='Diag Trace' ;