Create The World With Creativity
 
Welcome, Guest:Log in | Register | Information Center | Languages | Search | Tags | FAQs | Lite
There was a problem with the request. Check your permission or contact with administrator.




Your Ad Here

Grade this thread

Quote Favorites Report
Starter:  Topic: : Trace Analyzer - Analyzing SQL Trace (10046)
R.Wang 
5 Stars
 

Info: Moderator Offline Male
From: Not Specified 
Posts: 323  
Digest 0  
Credits: 57
Money: 1719 $OraclePoint
Registered on 2007-04-20
ProfileProfile BuddyBuddy PMPM Reply Reply QuotesQuotes   1 F 
Trace Analyzer - Analyzing SQL Trace (10046)



Trace Analyzer is a tool which reads and parses on eor several SQL traces generated by SQL Trace or by event 10046 at any level (1, 4, 8 or 12) and produces a comprehensive report with performance related details.
[url=http://www.oraclepoint.com]sP7ESBbwfOraclePointZH1iMd35J[/url]


Note: Activating event 10046 as following:
alter session set events '10046 trace name context forever, level num';
[url=http://www.oraclepoint.com]JypHfhTgWOraclePointsSraA7XEP[/url]

          Where num is either 1,4,8 or 12, with 1 being the same as a normal set sql_trace=true, 4 including values of bind variables, 8 including
          wait events, and 12 including both bind variables and wait events.
[url=http://www.oraclepoint.com]YgB56IueUOraclePointOXPXgDCoj[/url]

Report generated includes:
  • response time components,
  • db call summaries;
    [url=http://www.oraclepoint.com]k9G7qYoGYOraclePointled1303x6[/url]

  • list of top SQL according to response time;
  • SQL genealogy with recursive dependencies;
  • segment i/o wait summaries;
    [url=http://www.oraclepoint.com]BhaWvylJUOraclePointpL0Pw8Wtn[/url]

  • hot blocks;
  • gaps of no tracing activity;
  • transaction summary;
  • non-default initialization parameters;
    [url=http://www.oraclepoint.com]uXuJ0On1HOraclePointns5jtb0FN[/url]

  • row source plans;
  • explain plans;
  • tables and indexes referenced by explain plans;
    [url=http://www.oraclepoint.com]xrWIXiHnUOraclePointE0Dsubc5b[/url]

  • indexed columns;
  • CBO statistics for tables, indexes and their columns;
  • bind variables used by relevant SQL;
    [url=http://www.oraclepoint.com]riRyLAsutOraclePointKuzXihtr6[/url]

  • time analysis for SQL itself and their progeny;
  • list and details of relevant executions for top SQL.
Installation Guide:
[url=http://www.oraclepoint.com]Ryjm4jqmUOraclePointHEOjvw1j9[/url]

   # cd trca/install
   # sqlplus /nolog
   SQL> connect / as sysdba
[url=http://www.oraclepoint.com]1Stkdea1COraclePoint8kt43icec[/url]

   SQL> start tacreate.sql

Source of Trace Analyzer: Oracle Metalink Note: 224270.1
[url=http://www.oraclepoint.com]CLEWSIk25OraclePointXseViwFJP[/url]


Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0 to 11.1
[url=http://www.oraclepoint.com]jjGlhqVajOraclePoint44EW6PaRi[/url]

OSS Support Tools - Version: 9.2.0 to 11.1
Oracle Application Object Library - Version: 11.5.5 to 12.0
Information in this document applies to any platform.
[url=http://www.oraclepoint.com]j3adPI8lrOraclePointuq1APZH28[/url]


Note: Trace Analyzer is highly recommended to be installed when use XECUTE method (SQLTXPLAIN), but not mandatory. If installed, XECUTE report consists more statistics details, such of "segemnt statistics".
[url=http://www.oraclepoint.com]yNXXHRbdMOraclePointq4ePdWp7m[/url]



[url=http://www.oraclepoint.com]x5Nfp5VqKOraclePointvxBslPG9W[/url]



[Lasted edited on 2008-07-22 14:20 R.Wang ]


Tags: utility scripts 

2008-07-22 14:09
  Grade this thread



Similar Threads Forum Author Replies Views Last Post
Oracle's Block Browser and Editor tool
Oracle Tools, Utilities & Scripts outility 0 482  2009-10-09 12:45
Google Has Open Sourced Page Speed for Web Development
Enterprise Computing and Architecture R.Wang 0 1036  2009-06-10 15:06
Provide Oracle Performance Healthcheck
Oracle Tools, Utilities & Scripts Rui 3 8932  2009-06-08 10:24
The Top 75 Open Source Security Apps
Oracle Database Security R.Wang 0 850  2009-04-01 16:36
DBMoto for Database Data Replication
Oracle Tools, Utilities & Scripts R.Wang 0 768  2009-03-23 15:11

  Quick Response
Title:
Content:




Upload: Disable
Username:
Password:
  



Recommend to a friend Print Article Mode





 


Powered by BMForum Powered by BMForum 2007 5.6 RSS Feed  
Processed in 0.11905097 second(s),8 queries  
Top