alter session set events跟踪文件在哪
答案:2 悬赏:20 手机版
解决时间 2021-03-09 02:06
- 提问者网友：沉默的哀伤
- 2021-03-08 12:16
alter session set events跟踪文件在哪
最佳答案
- 五星知识达人网友：英雄的欲望
- 2021-03-08 12:52
SELECt d.VALUE
|| '/'
|| LOWER (RTRIm (i.INSTANCE, CHR (0)))
|| '_ora_'
|| p.spid
|| '.trc' trace_file_name
FROM (SELECt p.spid
FROM v$mystat m, v$session s, v$process p
WHERe m.statistic# = 1 AND s.SID = m.SID AND p.addr = s.paddr) p,
(SELECt t.INSTANCE
FROM v$thread t, v$parameter v
WHERe v.NAME = 'thread'
AND (v.VALUE = 0 OR t.thread# = TO_NUMBER (v.VALUE))) i,
(SELECt VALUE
FROM v$parameter
WHERe NAME = 'user_dump_dest') d
/
|| '/'
|| LOWER (RTRIm (i.INSTANCE, CHR (0)))
|| '_ora_'
|| p.spid
|| '.trc' trace_file_name
FROM (SELECt p.spid
FROM v$mystat m, v$session s, v$process p
WHERe m.statistic# = 1 AND s.SID = m.SID AND p.addr = s.paddr) p,
(SELECt t.INSTANCE
FROM v$thread t, v$parameter v
WHERe v.NAME = 'thread'
AND (v.VALUE = 0 OR t.thread# = TO_NUMBER (v.VALUE))) i,
(SELECt VALUE
FROM v$parameter
WHERe NAME = 'user_dump_dest') d
/
全部回答
- 1楼网友：孤独入客枕
- 2021-03-08 13:52
你说呢...
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯