TVD$XTAT在linux下安装使用详解

mac2022-06-30  102

扩展跟踪文件分析工具 (TVD$XTAT)是个命令行工具.和TKPROF一样,主要目的是把原始跟踪文件作为输入内容生成一个格式化的文件作为输出内容.输出文件可以是HTML或是文本文件.界面非常友好,推荐使用下面是安装过程:1.下载介质https://antognini.ch/2009/04/tvdxtat-40-beta-9/2.root用户修改 tvd$xtat的所属用户和所属组[root@Oracle11g ~]# chown -R oracle:oinstall tvdxtat_40beta11_20170301.zip 3.oracle建立专门的目录,专对 tvd$xtat[oracle@Oracle11g ~]$ mkdir tvdxtat[oracle@Oracle11g ~]$ mv tvdxtat_40beta11_20170301.zip  tvdxtat4.解压该文件[oracle@Oracle11g ~]$ cd tvdxtat[oracle@Oracle11g tvdxtat]$ unzip tvdxtat_40beta11_20170301.zip Archive:  tvdxtat_40beta11_20170301.zip  inflating: changelog.txt             inflating: config/logging.properties    inflating: config/tvdxtat.properties    inflating: doc/commons-cli-license.txt    inflating: doc/tvdxtat-license.html   extracting: images/deed.gif          extracting: images/deed2.gif          inflating: images/deeds.css          inflating: images/logo_deed.gif     extracting: images/somerights20.gif   extracting: images/trivadis.gif       inflating: lib/commons-cli-1.0.jar    inflating: lib/tvdxtat.jar           inflating: readme.html               inflating: templates/active.xsl      inflating: templates/html.xsl        inflating: templates/text.xsl        inflating: templates/tvdxtat.xsd     inflating: tvdxtat.cmd               inflating: tvdxtat.sh                5.修改文件tvdxtat.sh[oracle@Oracle11g tvdxtat]$ echo $ORACLE_HOME   --确认oracle_home/u01/app/oracle/product/11.2.0/db_1[oracle@Oracle11g tvdxtat]$ ls -l /u01/app/oracle/product/11.2.0/db_1/jdk/jre  --确认java_home总计 124drwxr-xr-x  2 oracle oinstall  4096 2014-09-16 bin-rwxr-xr-x  1 oracle oinstall   969 2008-10-31 CHANGES-rwxr-xr-x  1 oracle oinstall  2487 2008-10-31 COPYRIGHTdrwxr-xr-x 14 oracle oinstall  4096 2014-09-16 lib-rwxr-xr-x  1 oracle oinstall 13237 2008-10-31 LICENSE-rwxr-xr-x  1 oracle oinstall 13936 2008-10-31 README-rwxr-xr-x  1 oracle oinstall 67235 2008-10-31 THIRDPARTYLICENSEREADME.txt-rwxr-xr-x  1 oracle oinstall   969 2008-10-31 Welcome.html[oracle@Oracle11g tvdxtat]$ vi  tvdxtat.sh   --修改文件#!/bin/sh#JAVA_HOME=/u00/app/oracle/product/11.2.0.4/jdk/jre/  --保留原内容JAVA_HOME=/u01/app/oracle/product/11.2.0/db_1/jdk/jre  --指定为实际路径TVDXTAT_HOME=/home/oracle/tvdxtat   --指定为实际路径--以下默认即可$JAVA_HOME/bin/java -Xmx1024m -Dtvdxtat.home=$TVDXTAT_HOME -Djava.util.logging.config.file=$TVDXTAT_HOME/config/logging.properties -jar $TVDXTAT_HOME/lib/tvdxtat.jar $*~~~6.使用 tvd$xtat.sh[oracle@Oracle11g tvdxtat]$ ./tvdxtat.sh -i /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_ora_8372_10046.trc -o /home/oracle/prod_ora_8372_10046.html -s no -w yes00:00:00 WARNING automatically switch to release 11 (configured=12 detected=11)00:00:00 WARNING line 1726 not processed[oracle@Oracle11g tvdxtat]$ vi /home/oracle/pprod_ora_3360.html        prod_ora_3360.xml         prod_ora_8372_10046.html  purchaseOrder.xml         [oracle@Oracle11g tvdxtat]$ vi /home/oracle/prod_ora_8372_10046.html <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"><html lang="en"><head><META http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>TVD$XTAT Output</title><style type="text/css">                                body { background-color: rgb(244,244,244); }                                h1 { color: rgb(55,55,55); font-family: helvetica; font-size: 15pt; font-weight: bold; }                                h2 { color: rgb(55,55,55); font-family: helvetica; font-size: 13pt; font-weight: bold; }                                h3 { color: rgb(55,55,55); font-family: helvetica; font-size: 11pt; font-weight: bold; }                                p { color: rgb(55,55,55); font-family: helvetica; font-size: 10pt; font-weight: normal; }                                a { color: rgb(55,55,55); font-family: helvetica; font-size: 10pt; font-weight: normal; }                                a.th { color: rgb(244,244,244); background-color: rgb(55,55,55); font-family: helvetica; font-size: 10pt; font-weight: normal; }                                p.error { color: rgb(255,0,0); font-family: helvetica; font-size: 10pt; font-weight: normal; }                                th.color { color: rgb(244,244,244); background-color: rgb(55,55,55); font-family: helvetica; font-size: 10pt; font-weight: normal; vertical-align: top; }                                th.no_color { color: rgb(55,55,55); font-family: helvetica; font-size: 10pt; font-weight: normal; vertical-align: top; }                                td.color { color: rgb(55,55,55); background-color: rgb(220,208,192); font-family: helvetica; font-size: 10pt; font-weight: normal;  vertical-align: top; }                                td.color_pre { color: rgb(55,55,55); background-color: rgb(220,208,192); font-family: helvetica; font-size: 10pt; font-weight: normal; white-space: pre; vertical-align: top; }                                td.no_color { color: rgb(55,55,55); font-family: helvetica; font-size: 10pt; font-weight: normal; vertical-align: top; }                                td.no_color_pre { color: rgb(55,55,55); font-family: helvetica; font-size: 10pt; font-weight: normal; white-space: pre; vertical-align: top; }                        table { border: 0px solid rgb(55,55,55); border-collapse: separate; border-spacing: 2px 2px; }                        </style><script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js" type="text/javascript"></script><script type="text/javascript">                                $(document).ready(function() {                                        $(".toggle").click(function() {                                                var text = $(this).text();                                                if (text.indexOf("hide") != -1) {                                                        $(this).text(text.replace("hide", "show"));                                                }                                                else {                                                        $(this).text(text.replace("show", "hide"));                                                }                                                $(this).parent().next().toggle("slow");                                                return false;                                        });                                        --7.GUI窗口查看该文件 prod_ora_8372_10046.html ,效果非常棒

 

转载于:https://www.cnblogs.com/iyoume2008/p/6953723.html

相关资源:TVD参考资料.rar
最新回复(0)