(转)如何获得跟踪文件名称
来源:互联网 发布:c语言逻辑表达式的值 编辑:程序博客网 时间:2024/05/23 10:38
当我们使用sql_trace/10046等事件进行进程跟踪时,会生成跟踪文件.跟踪文件名称由以下几部分组成:
<sid>_ora_<pid>.trc
以下脚本用户获得跟踪文件名称:
For Unix:
$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Oct 8 12:08:09 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL> set echo on
SQL> @gettrcnameunix
SQL> SELECT d.VALUE
2 || '/'
3 || LOWER (RTRIM (i.INSTANCE, CHR (0)))
4 || '_ora_'
5 || p.spid
6 || '.trc' trace_file_name
7 FROM (SELECT p.spid
8 FROM v$mystat m, v$session s, v$process p
9 WHERE m.statistic# = 1 AND s.SID = m.SID AND p.addr = s.paddr) p,
10 (SELECT t.INSTANCE
11 FROM v$thread t, v$parameter v
12 WHERE v.NAME = 'thread'
13 AND (v.VALUE = 0 OR t.thread# = TO_NUMBER (v.VALUE))) i,
14 (SELECT VALUE
15 FROM v$parameter
16 WHERE NAME = 'user_dump_dest') d
17 /
TRACE_FILE_NAME
--------------------------------------------------------------------------------
/opt/oracle/admin/hsbill/udump/hsbill_ora_29630.trc
For Nt:
SQL> SELECT d.VALUE
2 || '\'
3 || LOWER (RTRIM (i.INSTANCE, CHR (0)))
4 || '_ora_'
5 || p.spid
6 || '.trc' trace_file_name
7 FROM (SELECT p.spid
8 FROM v$mystat m, v$session s, v$process p
9 WHERE m.statistic# = 1 AND s.SID = m.SID AND p.addr = s.paddr) p,
10 (SELECT t.INSTANCE
11 FROM v$thread t, v$parameter v
12 WHERE v.NAME = 'thread'
13 AND (v.VALUE = 0 OR t.thread# = TO_NUMBER (v.VALUE))) i,
14 (SELECT VALUE
15 FROM v$parameter
16 WHERE NAME = 'user_dump_dest') d
17 /
TRACE_FILE_NAME
--------------------------------------------------------------------------------
e:\oracle\admin\eygle\udump\eygle_ora_3084.trc
<sid>_ora_<pid>.trc
以下脚本用户获得跟踪文件名称:
For Unix:
$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Oct 8 12:08:09 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL> set echo on
SQL> @gettrcnameunix
SQL> SELECT d.VALUE
2 || '/'
3 || LOWER (RTRIM (i.INSTANCE, CHR (0)))
4 || '_ora_'
5 || p.spid
6 || '.trc' trace_file_name
7 FROM (SELECT p.spid
8 FROM v$mystat m, v$session s, v$process p
9 WHERE m.statistic# = 1 AND s.SID = m.SID AND p.addr = s.paddr) p,
10 (SELECT t.INSTANCE
11 FROM v$thread t, v$parameter v
12 WHERE v.NAME = 'thread'
13 AND (v.VALUE = 0 OR t.thread# = TO_NUMBER (v.VALUE))) i,
14 (SELECT VALUE
15 FROM v$parameter
16 WHERE NAME = 'user_dump_dest') d
17 /
TRACE_FILE_NAME
--------------------------------------------------------------------------------
/opt/oracle/admin/hsbill/udump/hsbill_ora_29630.trc
For Nt:
SQL> SELECT d.VALUE
2 || '\'
3 || LOWER (RTRIM (i.INSTANCE, CHR (0)))
4 || '_ora_'
5 || p.spid
6 || '.trc' trace_file_name
7 FROM (SELECT p.spid
8 FROM v$mystat m, v$session s, v$process p
9 WHERE m.statistic# = 1 AND s.SID = m.SID AND p.addr = s.paddr) p,
10 (SELECT t.INSTANCE
11 FROM v$thread t, v$parameter v
12 WHERE v.NAME = 'thread'
13 AND (v.VALUE = 0 OR t.thread# = TO_NUMBER (v.VALUE))) i,
14 (SELECT VALUE
15 FROM v$parameter
16 WHERE NAME = 'user_dump_dest') d
17 /
TRACE_FILE_NAME
--------------------------------------------------------------------------------
e:\oracle\admin\eygle\udump\eygle_ora_3084.trc
- (转)如何获得跟踪文件名称
- 如何获得跟踪文件名称
- 如何获得跟踪文件名称
- 如何获得跟踪文件名称
- DBA Scripts:获得跟踪文件名称的ge…
- 小秀:如何在获得了文件路径以后获得文件名称的方法!
- C#根据路径获得文件名称
- oracle下获得TRACE文件名称
- UI 如何批量修改文件名称
- C++ 获得指定目录下的所有文件名称
- 主题:如何获取系统文件名称及路径
- 如何查看头文件名称的意义
- C语言 如何获取文件名称 system dir
- 【转】如何调试跟踪Android源代码
- 如何跟踪某个session的SQL(转)
- 实体框架上下文跟踪:使用跟踪入口获得详细信息
- 如何跟踪ACPI代码
- 如何跟踪入侵IP
- JAVA ReentrantReadWriteLock AND 缓存系统
- 产品经理应该说NO
- REST with Spring series
- 泛型
- jquery mobile中的表单验证
- (转)如何获得跟踪文件名称
- oracle 检查点的两篇好文
- (转)工具分享:20个免费的网站测试工具
- php中挺好用的strtotime方法
- 2011 年85个jquery 导学教程
- jquery 中禁止表单多次提交
- Chrome赶超IE:谷歌为何再度联手火狐
- 360居然破坏了oracle 10g的emca
- ORALCE DBA学习1