.trc and .trm files in Oracle 11g
来源:互联网 发布:最小的刻录软件 编辑:程序博客网 时间:2024/06/06 01:17
What is .trc file?
Ans:Sql Trace Collection file
What is .trm file?
Ans:Trace map (.trm) file.Trace files(.trc) are sometimes accompanied by corresponding trace map (.trm) files, which contain structural information about trace files and are used for searching and navigation.
Doc ID 750982.1 explains this very well
------
(Doc ID 750982.1):TRM Trace Files Getting Generated in 11g Database
From 11g onwards, all the trace files are found in ADR_HOME/trace directory.
There is usually one “.trm” file for each “.trc” file.
The files located in the TRACE directory, with the “.trm” extensions, are called Trace Metadata files. The metadata in .trm files describe the trace records stored inside of .trc trace files.
The Trace metadata allows tools, such as Adrci, to post process the trace information.
By deleting the .trm file, you make the .trc file unusable for post processing from ADR using ADRCI tool.
------
<Related Topic>
What is ADR?
The Automatic Diagnostic Repository (ADR) is a file-based repository for storing diagnostic data. Because this repository is stored outside the database, the diagnostic data is available even when the database is down. As of Release 11g, the alert log, all trace and dump files, and other diagnostic data are also stored in the ADR.
What is an ADR HOME?
An ADR HOME is the root directory for all diagnostic dataa??traces, dumps, the alert log, and so ona??for a particular instance of a particular Oracle product or component.
The location of an ADR home is given by the following path, which starts at the ADR base directory:
diag/product_type/product_id/instance_id
Example of ADR HOMES:
diag/rdbms/orcl/ORCL1 (Product=rdbms, product_id=db_name=orcl, instance_id=ORACLE_SID=ORCL)
diag/asm/+asm/+ASM (Product=asm, product_id=+asm, instance_id=ORACLE_SID=+ASM)
diag/tnslsnr/node1/listener (Product=tnslsnr - SQL*NET Listener, product_id=hostname=node1, instance_id=listener name=listener)
Ans:Sql Trace Collection file
What is .trm file?
Ans:Trace map (.trm) file.Trace files(.trc) are sometimes accompanied by corresponding trace map (.trm) files, which contain structural information about trace files and are used for searching and navigation.
Doc ID 750982.1 explains this very well
------
(Doc ID 750982.1):TRM Trace Files Getting Generated in 11g Database
From 11g onwards, all the trace files are found in ADR_HOME/trace directory.
There is usually one “.trm” file for each “.trc” file.
The files located in the TRACE directory, with the “.trm” extensions, are called Trace Metadata files. The metadata in .trm files describe the trace records stored inside of .trc trace files.
The Trace metadata allows tools, such as Adrci, to post process the trace information.
By deleting the .trm file, you make the .trc file unusable for post processing from ADR using ADRCI tool.
------
<Related Topic>
What is ADR?
The Automatic Diagnostic Repository (ADR) is a file-based repository for storing diagnostic data. Because this repository is stored outside the database, the diagnostic data is available even when the database is down. As of Release 11g, the alert log, all trace and dump files, and other diagnostic data are also stored in the ADR.
What is an ADR HOME?
An ADR HOME is the root directory for all diagnostic dataa??traces, dumps, the alert log, and so ona??for a particular instance of a particular Oracle product or component.
The location of an ADR home is given by the following path, which starts at the ADR base directory:
diag/product_type/product_id/instance_id
Example of ADR HOMES:
diag/rdbms/orcl/ORCL1 (Product=rdbms, product_id=db_name=orcl, instance_id=ORACLE_SID=ORCL)
diag/asm/+asm/+ASM (Product=asm, product_id=+asm, instance_id=ORACLE_SID=+ASM)
diag/tnslsnr/node1/listener (Product=tnslsnr - SQL*NET Listener, product_id=hostname=node1, instance_id=listener name=listener)
- .trc and .trm files in Oracle 11g
- oracle 清理跟踪文件trc,trm
- Placement of Voting disk and OCR Files in Oracle RAC 10g and 11gR1 [ID 293819.1]
- Placement of Voting disk and OCR Files in Oracle RAC 10g and 11gR1 [ID 293819.1]
- How To Query And Change The Oracle Hidden Parameters In Oracle 10g and 11g (文档 ID 315631.1)
- Install Oracle 10g and 11g in Windows XP SP2.
- Using Intermediate Events and Advanced TaskService Interactions in Oracle BPM Suite 11g
- SQL trace, 10046, trcsess and tkprof in Oracle 10g
- pivot and unpivot queries in 11g
- pivot and unpivot queries in 11g
- pivot and unpivot queries in 11g
- trc
- Oracle 10g AND Oracle 11g手工建库案例--Oracle 11g
- Oracle 10g AND Oracle 11g手工建库案例--Oracle 11g
- Oracle 10g AND Oracle 11g手工建库案例--Oracle 10g
- Oracle 10g AND Oracle 11g手工建库案例之--Oracle 10g
- Virtual Columns in Oracle Database 11g
- uninstall oracle 11g in win 7
- CentOS安装MYSQL
- Qt问题集
- Android 菜单(OptionMenu)大全 建立你自己的菜单
- arm-linux-gcc安装 和 环境变量设置
- shell编程基础知识
- .trc and .trm files in Oracle 11g
- ThinkPHP3.0 RBAC示例登录验证失败无法返回登录解决
- 企业应用架构模式之领域逻辑模式
- java 敏感字过滤
- VirtualBox扩容vmdk格式的Windows分区
- 排序算法总结
- xcode4快捷键
- ORA-12528
- Android应用如何启动其他应用程序