SQL Query to Get Oracle Database Alertlog File Name with full directory folder path

SQL Query to Get Oracle Database Alertlog File Name with full directory folder path

set lines 300 pages 100

col path for a100
select 'tail -200f '||value||'/alert_'||(select instance_name from v$instance)||'.log'
as path from v$diag_info where name = 'Diag Trace';