oracle查看实例路径,定位oracle实例的当前跟踪文件名及路径

最新推荐文章于 2022-01-19 07:54:58 发布

点墨楼

最新推荐文章于 2022-01-19 07:54:58 发布

阅读量760

点赞数

文章标签： oracle查看实例路径

SQL> select u_dump.value || '/' || db_name.value || '_ora_' || v$process.spid || nvl2(v$process.traceid, '_' || v$process.traceid, null )|| '.trc' "Trace File" from v$parameter u_dump cross join v$parameter db_name cross join v$process join v$session on v$process.addr = v$session.paddr where u_dump.name = 'user_dump_dest' and db_name.name = 'db_name' and v$session.audsid=sys_context('userenv','sessionid');

Trace File

--------------------------------------------------------------------------------

/opt/ora10g/admin/ORCL/udump/ORCL_ora_2754.trc