*********************************************************************
* Description: Command of finding Oracle database alert log location
* Date: 05:47 PM EST, 12/01/2017
*********************************************************************
<1> Query view to address Oracle database alert log location:
|
|__ SQL> set linesize 200;
col value format a80;
select name,value from v$diag_info where name like '%Diag Trace%';
NAME VALUE
------------------ ------------------------------------------------------
Diag Trace /u01/app/oracle/diag/rdbms/orcl/nebftst2/trace
Your Comments