gettracename.sql
来源:互联网 发布:钢铁侠 蝙蝠侠 知乎 编辑:程序博客网 时间:2024/05/16 03:09
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
/
- gettracename.sql
- SQL
- SQL
- SQL
- sql
- sql
- SQL
- sql
- SQL (-)
- sql
- SQL
- SQL
- SQL
- sql
- sql
- sql
- sql
- SQL
- switch与if的区别(1)
- 常用网址
- ASP.NET进阶(7):认清控件之DataBind
- http状态码
- ASP.NET进阶(8):HttpModule和HttpApplication
- gettracename.sql
- CMS系统模版引擎设计(1):基础类型
- JavaScript的数据类型之Number, String, Boolean和Object
- CMS系统模版引擎设计(2):页面生产流程
- POJ 3348 Cows (计算凸包面积)
- CMS系统模版引擎设计(3):Label基类的设计
- CMS系统模板引擎设计(4):Parameter类设计
- 新博客测试
- Struts2 + Spring 整合