`
- 浏览:
11792349 次
- 性别:
- 来自:
深圳
-
.trc and .trm files in Oracle 11g
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)
分享到:
Global site tag (gtag.js) - Google Analytics
相关推荐
.trc文件转换工具,.trc转换为.asc,特别实用
dev_rfc.trc
http://blog.csdn.net/bjchangxiao/article/details/68489880
Log_NOK.trc
1_不冲电8888.trc
C1--Trace--00172.trc
C2--Trace--00172.trc
OTDR测试曲线trc转sor,可在OTDR仪器上,将trc格式曲线打开,在另存时,将格式选项为Dell..字样,保存后文件将为sor格式
逐行读取 .trc 文件并将元素存储在数组中。 VOID 元素存储为 NaN。
CAN网络报文TRC格式转ASC格式工具
大众带方向盘带倒车测试100kbit
奥迪TT-C7-Q3仪表开机_500kbits
Errors in file /u02/app/oracle/admin/unicom/udump/unicom_ora_661.trc: ORA-07445: \263\366\317\326\322\354\263\243: \272\313\320\304\327\252\264\242 [0000000101C3089C] [SIGSEGV] [Address not mappe d to...
SQL> oradebug setmypid Statement processed. SQL> oradebug unlimit .../oracle/ora10g/admin/jscn/udump/jscn1_ora_7755.trc SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 1
# Usage: [n]awk -f ass.awk fname.trc (But read the Portability Section !!) # # Configuring Ass: # # By default, 'ass' attempts to dump as much information as possible and # assumes that the output is...
sqlmonitor 1. 找出sid和serial# ... 例: D:\Oracle\product\10.1.0\admin\test10g\udump 6. 找最新的trace文件 7. 使用tkprof文件解析trace文件 例: tkprof sqltrace文件.trc a.out 8. 打开a.out
可以将PeakCan设备记录的文件.trc转成canoe能识别的.asc文件,然后利用CANOE进行报文数据分析
Oracle数据库归档,trc,监听log自动清理脚本
1.11 最近一次备份是否成功 ................................................................................................................................. 8 1.12 是否存在 1 周内失败的 JOB ..............
oracle系统状态trace文件分析器 当系统hang住时,或者进程间有阻塞时,你可以产生下面两种跟踪文件,一种是进程状态跟踪文件,一种是系统状态跟踪文件: process state dumps ==> 一个进程的所有对象状态,...