查看ORACLE日志文件存储目录

select value from v$diag_info where name='Diag Trace';
select value from v$parameter where name='background_dump_dest';