TRCANLZR (TRCA) SQL_TRACE/10046事件trace文件分析器（文档ID 224270.1）

最新推荐文章于 2021-04-03 01:44:12 发布

张玉龙

最新推荐文章于 2021-04-03 01:44:12 发布

阅读量349

点赞数

分类专栏： oracle优化学习

原文链接：https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=446743778428382&id=224270.1&_adf.ctrl-state=n5yegu6g7_52

版权

oracle优化学习专栏收录该内容

62 篇文章 4 订阅

订阅专栏

TRCANLZR (TRCA): SQL_TRACE/Event 10046 Trace File Analyzer - Tool for Interpreting Raw SQL Traces (NO LONGER SUPPORTED - Use SQLTXPLAIN sqltrcanlzr.sql) (Doc ID 224270.1)

TRCANLZR (TRCA): SQL_TRACE/Event 10046 Trace File分析器-分析原始SQL Traces的工具（不再支持-使用SQLTXPLAIN sqltrcanlzr.sql）

PURPOSE

Trace Analyzer, also known as TRCANLZR or TRCA, is depracated tool provided by Oracle Server Technologies Center of Expertise - ST CoE. TRCA inputs one or several SQL trace(s) generated by Event 10046 and outputs a diagnostics report in two formats (html and text). These reports are commonly used to diagnose processes performing poorly. Trace分析器，也称为TRCANLZR或TRCA，是Oracle服务器技术专业技术中心-ST CoE提供的已淘汰工具。TRCA输入Event 10046生成的一个或多个SQL trace(s)，并以两种格式(html and text)输出诊断报告。这些报告通常用于诊断性能不佳的过程。

The functionality provided by TRCANLZR is now included in SQLTXPLAIN as a script sqltrcanlzr.sql. A standalone installation of TRCANLZR is not supported.
TRCANLZR提供的功能现在作为脚本sqltrcanlzr.sql包含在SQLTXPLAIN中。不支持TRCANLZR的独立安装。
TRCA identifies expensive SQL out of the provided trace(s), then it connects to the database and collects their explain plans, Cost-based Optimizer CBO statistics, metadata, configuration parameters, and similar elements that influence the performance of the process being analyzed.
TRCA从提供的trace(s)中识别出消耗高的SQL，然后将其连接到数据库并收集其执行计划，基于成本的优化器CBO统计信息，元数据，配置参数以及影响性能的其他信息。
For best output results TRCA must be installed and used in the same system and database where the trace is generated. Understanding that installing TRCA in a production system is not always possible, TRCA is capable of analyzing a trace using a different system.Refer to the included instructions for details. 为了获得最佳输出结果，必须在生成trace的同一系统和数据库中安装和使用TRCA。了解到并非总是可以在生产系统中安装TRCA，TRCA能够使用其他系统分析trace。有关详细信息，请参阅随附的说明。

TROUBLESHOOTING STEPS

For 9i, 10g and 11g instances, download tool trca.zip from attachments. Read trca_instructions.html included into zip file.
对于9i, 10g and 11g实例，请从attachments下载工具trca.zip 。阅读zip文件中包含的trca_instructions.html。也可以在此下载https://pan.baidu.com/s/1lRtBscBDHq8qWCoGYOwiPw
If zip file seems corrupted (IE browser), or for other issues during the installation, please add a comment to this article.
如果zip文件似乎已损坏（IE浏览器），或者在安装过程中出现其他问题，请在本文中添加注释。
For sample output reports, download trca_samples.zip.
有关示例输出报告，请下载trca_samples.zip。也可以在此下载https://pan.baidu.com/s/1lRtBscBDHq8qWCoGYOwiPw